Jump to content

Archived

This topic is now archived and is closed to further replies.

firelior

database problem-mysql_fetch_object()

Recommended Posts

Hi,
I have this:
[code]SELECT * FROM cars WHERE `area` LIKE '%ירושלים%'[/code]
which is in hebrew.
now. when I enter this through the phpmyadmin I don't get any error but when I do this:
[code]
$sql="SELECT * FROM cars WHERE `area` LIKE '%ירושלים%'";
$result = mysql_query($sql);
while ($row = mysql_fetch_object($result))
{
      echo $row->id;
}
[/code]
I get this error:
[code]Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource[/code]
Please help.
THANKS

Share this post


Link to post
Share on other sites
OK, I'd have thought that the query failed... Try this:

[code]
$sql="SELECT * FROM cars WHERE `area` LIKE '%ירושלים%'";
$result = mysql_query($sql) or die ("Couldn't execute $sql: " .mysql_error());
[/code]

Regards
Huggie

Share this post


Link to post
Share on other sites
might want to try and escape out the value before the query

[code]$value = mysql_real_escape_string("ירושלים");
$sql="SELECT * FROM cars WHERE `area` LIKE '%$value%'";[/code]

Ray

Share this post


Link to post
Share on other sites
ok,
[b]huggy[/b]: what it does is this: [code]Couldn't execute SELECT * FROM cars WHERE `area` LIKE '%ירושלים%': Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like'[/code]

and ray..it doesn't work. its still the same

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.