Code Forums - View Single Post

Sonny1973 · 04-10-2005, 05:53 AM

i'd like to know how you would structure the following query for multiple selectnames (which are all contained in the search form, via drop down menu options):

$query = mysql_query("SELECT * FROM tablename WHERE selectname LIKE '%$search%' LIMIT 0, 50"

also, i'd like to get rid of the Search box in the search form. so in other words i don't want to reference a search value, '%$search%', at all. thanks for any help in advance.

04-10-2005, 05:53 AM	#1 (permalink)
Sonny1973 Registered User Join Date: Mar 2005 Posts: 7	Query string i'd like to know how you would structure the following query for multiple selectnames (which are all contained in the search form, via drop down menu options): $query = mysql_query("SELECT * FROM tablename WHERE selectname LIKE '%$search%' LIMIT 0, 50" also, i'd like to get rid of the Search box in the search form. so in other words i don't want to reference a search value, '%$search%', at all. thanks for any help in advance.