Search function does not work if there are too many results

hello,

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

PHP:

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);

PHP:

Any suggestions?

 

Try to minimize the results using LIMIT 0,10, make pagination.

Peace,

 

Maybe your PHP version is too old? http://bugs.php.net/bug.php?id=16906&edit=1

 

checked it. It is the latest version I have got

That is what i am doing. But it is not showing any results at all.

 

Try to repair your tables, try a tip from the url given above:

 

I've had a file with more than 8,000,000 entries and never saw similar errors .. What's your MySQL client version ?

 

please check your mysql temp dir may it is full
clear it and then try to run sql.

 

How big is this database you are searching through?

What "special characters" does it fail on?