Posted by Dave Mennenoh on 02/14/06 18:44

>>$query = select * from books where ".$searchtype." like
>>'%".$searchterm."%'" ;

Besides missing the leading quotation mark, you might like to know that you
don't need to do concatenation like this using PHP - so you can simply do
this:

$query = select * from books where $searchtype like '%$searchterm%'" ;

weird huh!

--
Dave -
www.blurredistinction.com
www.macromedia.com/support/forums/team_macromedia/

[Back to original message]