how to repair this error then translating from eglish to hebrew :

i use phpas script .

what is this error say ? because i happen then i chaged all my data to utf-8 in the data base and translated it to hebrew !!!

if (!($limit)){
$limit = $max_results;} // Default results per-page.
if (!($page)){
$page = 0;} // Default page value.
if (!$searchterm)
$sql_query = "SELECT * from games WHERE gamestatus = 1 $browseby";
else
$sql_query = "SELECT * from games WHERE gamestatus = 1 AND (gametitle LIKE \"%$searchterm%\" OR gamedesc LIKE  \"%$searchterm%\" OR gamekeywords LIKE \"%$searchterm%\" OR instructions LIKE \"%$searchterm%\" OR gamefile LIKE \"%$searchterm%\")";
$numresults = mysql_query($sql_query); // the query.
$numrows = mysql_num_rows($numresults); // Number of rows returned from above query.
// here line 66
if (!empty($searchterm)){
// LOG SEARCH RESULTS
      $searchterm2 = strtolower($searchterm);
 
      $now = time();

PHP:

 

anyone ???
are you saying that is no solution for this ?

 

something's wrong with the SQL query that's running. My guess is this line:

$sql_query = "SELECT * from games WHERE gamestatus = 1 $browseby";

Looks like you need an ORDER BY in there...

$sql_query = "SELECT * from games WHERE gamestatus = 1 ORDER BY $browseby";

Although I have no idea what's in the $browseby var.

 

thanks . but in english it works . it should be something else .

 

Not sure exactly what you mean, but try setting your mysql charset right after you create your db connection:

mysql_set_charset('utf8');

More info: http://us2.php.net/manual/en/function.mysql-set-charset.php

 

thanks . it is not it.