>>> I STFW and RTFM and I still can't figure out why this returns a 1064

>>> parse error:
>>>
>>> SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR 
>>> 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND 
>>> 'status' = 'active';

Why don't you try rebuilding the query. I mean go into phpmyadmin and
issue select * from `my_table` if that works. Then add on one where
clause
Select * FROM `my_table` WHERE (`field_1 LIKE '%key%' )  , and just put
it back together piece by piece until it breaks. That should at least
help narrow down what is breaking.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to