Posted by David Haynes on 02/14/06 18:57

Dave Mennenoh wrote:
>>> $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!
>

You also might like to use a format like:

$query = <<<EOQ
SELECT *
FROM books
WHERE {$searchtype} LIKE '%{$searchterm}%'
EOQ;

Which make the whole query a lot clearer to those used to SQL CLI
environments.

-david-

[Back to original message]