<?php


echo '  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">';

mysql_connect("localhost","root","");
mysql_select_db("***");
mysql_query("SET NAMES UTF8");
$getorder = mysql_query("SELECT *
FROM `orders`
WHERE CONCAT_WS( ' ', name, surname ) LIKE '%öçşiğü öçşiğü%'");
$dizi = mysql_fetch_array($getorder);

print_r($dizi);echo "<br><br><br>";


$getorder = mysql_query("SELECT *
FROM `orders`
WHERE CONCAT_WS( ' ', name, surname ) LIKE '%aaaa aaaa%'");
$dizi = mysql_fetch_array($getorder);

print_r($dizi);


 ?>

-- phpMyAdmin SQL Dump
-- version 4.0.6deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 19, 2013 at 12:42 AM
-- Server version: 5.5.34-0ubuntu0.13.10.1
-- PHP Version: 5.5.3-1ubuntu2.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `btc-faucet`
--

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `name` varchar(60) NOT NULL,
  `surname` varchar(60) NOT NULL,
  `telephone` bigint(11) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  `product_id` int(4) NOT NULL,
  `product_option` varchar(150) NOT NULL,
  `order_descrtiption` text NOT NULL,
  `payment_type` int(2) NOT NULL,
  `cargo` int(2) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` int(2) NOT NULL,
  `call` int(2) NOT NULL,
  `lastchange` varchar(20) NOT NULL,
  `personal_id` varchar(2) NOT NULL,
  `excel` int(1) NOT NULL,
  `site` int(3) NOT NULL,
  `ref` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `date`, `time`, `name`, `surname`, `telephone`, `address`, `city`, `country`, `product_id`, `product_option`, `order_descrtiption`, `payment_type`, `cargo`, `ip`, `status`, `call`, `lastchange`, `personal_id`, `excel`, `site`, `ref`) VALUES
(1, '0000-00-00', '00:00:00', 'öçşiğü', 'öçşiğü', 0, '', '', '', 0, '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0),
(2, '0000-00-00', '00:00:00', 'aaaa', 'aaaa', 0, '', '', '', 0, '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;