Search page connected to database.

[Anon]

I need a search form to search people i inserted in my database. The fields I want to search in are:

Firsname
Lastname
YOB --> year of birth
Country
Group

Does someone know a script for this...? I\'m using MySQL.

[Anon]

<?php

if($submit)
{
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "dbase name";

$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

mysql_query("SELECT * FROM $dbtable WHERE firstname LIKE '%$keyword%'");

{
//get columns
$name = $row[0];
$address = $row[1];
//blah blah

print ("<table><tr>\n<td><font face='arial' size='2'>$name</font></td>\n");
print ("<td><font face='arial' size='2'>$adress</font></td>\n</tr>\n");
//blah blah blah
print ("</table>");
}

}

else
{
print ("<form action='$PHP_SELF' method='post'>");
print ("<input type='text' name='keyword'><br>");
print ("<input type='submit' name='submit' value='Submit'>");
print ("</form>");
}
?>

HTH
scott d~

[Anon]

Scott's answer is okay but it only searches one field and you want to search five so you could use:

$sql .= "SELECT * FROM $dbtable WHERE ";
$sql .= "((Firstname LIKE '%$keyword%') OR ";
$sql .= "(Lastname LIKE '%$keyword%') OR ";
$sql .= "(YOB LIKE '%$keyword%') OR ";
$sql .= "(Country LIKE '%$keyword%') OR ";
$sql .= "(Group LIKE '%$keyword%'))";

mysql_query($sql, $db);