[SOLVED] Search help

[forumnz]

I want my script to search more than one field in a table, but whenever I add more than 1 i get error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/www/vhosts/somewhere.com/httpdocs/clickme/search2.php on line 36

 

Code snippet:

$query = "select * from clickme where 'keywords', 'buzzname' like \"%$trimmed%\"  
  order by keywords";

 

Thanks,

Sam.

[trq]

Because your syntax is foobar'd.

 

$query = "SELECT * FROM clickme WHERE keywords LIKE '%$trimmed%' OR buzzname LIKE '%$trimmed%' ORDER BY keywords";