TalkPHP - View Single Post

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.

08-20-2008, 05:32 PM	#1 (permalink)
Jako The Wanderer Join Date: Jun 2005 Posts: 21 Thanks: 1	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.