Results.php page
Posted: Sat Apr 16, 2005 4:09 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 multiple drop down menus):
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. all of the possible options for each selectname will be contained in their respective drop-down menus.
also is it possible to generate a customized (by me, the webmaster) visitor search form for MySQL database, using phpAdmin? if not, what front-end user software would anyone recommend?
thanks for any help in advance.
Code: Select all
$query = mysql_query("SELECT * FROM tablename WHERE selectname LIKE '%$search%' LIMIT 0, 50"also is it possible to generate a customized (by me, the webmaster) visitor search form for MySQL database, using phpAdmin? if not, what front-end user software would anyone recommend?
thanks for any help in advance.