[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