Search does not work if there are too many results

[baris22]

Search does not work if there is a special character in results

hello,

As i said on the title, if i get a special character in result from the search it does not work

I get this error

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/xxx/public_html/search.php on line 277

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/search.php on line 278

If there is no special character in results it works perfect. What can i do to find the special character? this is the code i am using.

$query = "select * from  files where title like \"%$trimmed%\"  
  order by added desc"; // 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

Any suggestions?

 

[Kate]

Have a look at the mysql_real_escape_string function.

PS: a single quote (') is usually used with strings in SQL.