Re: Search Script

And Maureen is right! We just so *used* to seeing equal signs in SELECT statements. Smacking fist on head .... Miles Thompson At 02:23 PM 4/25/2002 +0000, Maureen wrote:

The query should read as below, without the = after the LIKE: $query = "SELECT uid, id, image, iname, quantity, type FROM {$config["prefix"]}_shop WHERE iname LIKE '%$shopsearch% ORDER BY iname'"; HTH Maureen Jennifer Downey <jendowney@attbi.com> said: Hi all, I have been trying to build a search script for my site that deals with only one table in my db. As Julie Meloni pointed out look in the MySQL manual for LIKE clauses I can't seem to locate that clause in ether manual. Dan Brunner gave me this to go on: $query = "SELECT uid, id, image, iname, quantity, type FROM {$config["prefix"]}_shop WHERE iname LIKE = '%$shopsearch% ORDER BY iname'"; $ret = mysql_query($query); while(list($quantity)=mysql_fetch_row($ret)) But I can't seem to get this to work. I have never worked with LIKE before and would appreciate any help on this. Thanks Julie and Dan for your time and effort. Thanks all for your time and help Jennifer -- The sleeper has awaken --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php