TalkPHP - Keyword Search Form

TalkPHP (http://www.talkphp.com/forums.php)

- General (http://www.talkphp.com/general/)

- - Keyword Search Form (http://www.talkphp.com/general/3265-keyword-search-form.html)

Keyword Search Form

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.

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 :)