On Sun, 17 Mar 2002, Daniel Negron/KBE wrote:
> $sql= "SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%'
> ORDER BY artist ASC";
How about:
SELECT * FROM cd_list WHERE searchstring LIKE '%{$searchstring}%'
Then again, do you actually have a column called "searchstring" in your
table?
In any case, the way you had it didn't seem to make much sense unless you
wanted to search a user-supplied column for a string that literally
contained the string "searchstring".
miguel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
