Brian Dunning <mailto:[EMAIL PROTECTED]>
on Friday, April 23, 2004 8:19 AM said:
> SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR
> 'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND
> 'status' = 'active';
have you tried simply:
SELECT * FROM my_table WHERE status = 'active';
??
if that works move up into:
SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%') AND status =
'active';
if that works continue until you get an error.
chris.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
