I whipped up a quick search results page. You will need to create an html page with the form, the search field needs to be called 'search' based on this script.
If you want more results look into like statements in mysql and change the query. I also had to guess your DB has no ints, if so, you'll need to change the query.This is only one of about a thousand ways to do this.
I did not test the script, so if there's a typo, sorry.
<?
foreach (array_keys($_GET) as $key) {
$$key = $_GET[$key];
}
@ $db = mysql_connect($sql_lloc, $sql_user, $sql_pass);
if (!$db) {
echo "Could Not Connect To Database";
exit;
}
mysql_select_db($sql_name);
$query = "select * from pi_employee where (id = '".$search."' or firstname = '".$search."' or lastname = '".$search."' or phonenumber = '".$search."' or emailaddress = '".$search."' or specailty = '".$search."' or position = '".$search."' or yearinindustry = '".$search."' or notes = '".$search."')";
$result = mysql_query($query);
$num = mysql_num_rows($result);
for ($i=0; $i<$num; $i++) {
$row = mysql_fetch_array($result);
echo $row['firstname']." - Finish echoing results...<br>";
}
?>
Hope this helps.
