Keyword Search Form

Jako · 08-20-2008, 05:32 PM

What's the easiest way to have a keyword search form?

Right now I have a successful search form, but the user must select a drop-down menu for the specific type of search they are making.

I'm using something like this right now.

PHP Code:


			
$sql = "SELECT * FROM club WHERE club.club_name like 
            '%$query%' ORDER BY club.club_name ASC";

$result = mysql_query($sql) or die(mysql_error());

PHP Code:


			
while($row = mysql_fetch_assoc($result)) {
//yada yada yada
}

Right now the above is if the user selected the club from the form drop-down. But, if someone also types in another keyword, like a last name, I want to query that as well.

I could probably write the sql query, just not sure how to echo it all, since each table that the information is stored in has different names.

Jim · 08-21-2008, 07:44 AM

PHP Code:


			


$searchTypes = array('club_name', 'last_name'); // etc etc



if(in_array($_POST['searchType'], $searchTypes)) 

{

  $sql = "SELECT * FROM club WHERE ".$_POST['searchType']." like 

            '%$query%' ORDER BY club.club_name ASC";



  $result = mysql_query($sql) or die(mysql_error()); 

} 

else 

{

  trow new Exception('zOMG no seachtype found!');

}

Something like this should work :)