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

*slaps forehead*

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

The single quoted variables do not get parsed

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

Reply via email to