I think you want to remove the single quotes around the field names.

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


>>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';
>>
>>Anyone? TIA!
>>
>>- B1ff Lamer

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

Reply via email to