[snip] SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%') AND status = 'active';
if that works continue until you get an error. [/snip] That'll give you an error right there. That old single quoted variable will get you every time. :) WHERE (field_1 LIKE '%$keyword%') WHERE (field_1 LIKE '%" . $keyword . "%') -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php