I have a MySQL database containing tables with Arabic data (Varchar type exactly), I try to print a select query string thought php but it prints the values as zeros, Here's my query :
SELECT *,(
CASE WHEN `name_singular`= "قَائِدان" THEN "name_singular"
WHEN `name_twoA`= "قَائِدان" THEN "name_twoA"
WHEN `name_pluralA`= "قَائِدان" THEN "name_pluralA"
WHEN `name_twoO`= "قَائِدان" THEN "name_twoO"
WHEN `name_pluralO`= "قَائِدان" THEN
"name_pluralO" else NULL END) AS `field`
FROM `name` WHERE `name_singular`= "قَائِدان" OR
`name_twoA`= "قَائِدان" OR
`name_pluralA`= "قَائِدان" OR
`name_twoO`= "قَائِدان" OR
`name_pluralO`= "قَائِدان" LIMIT 0, 10 ;
and that's what i got as a result of printing the query string. it works fine when executing it thought mysql directly, but when using php it returns null
SELECT *,
( CASE
WHEN `name_singular` = "0" THEN "name_singular"
WHEN `name_twoa` = "0" THEN "name_twoa"
WHEN `name_plurala` = "0" THEN "name_plurala"
WHEN `name_twoo` = "0" THEN "name_twoo"
WHEN `name_pluralo` = "0" THEN "name_pluralo"
ELSE NULL
end ) AS `field`
FROM `name`
WHERE `name_singular` = "0"
OR `name_twoa` = "0"
OR `name_plurala` = "0"
OR `name_twoo` = "0"
OR `name_pluralo` = "0"
LIMIT 0, 10
And that's the php code :
<?php $query = 'the query string above ';
echo $query; $array=mysql_fetch_object(mysql_query($query));
var_dump($array);
?>