<?include "conninfo.php";

//Get data from form
$search1=$_POST["fn"];
$search2=$_POST["sn"];

//Write query
$query="SELECT * FROM people WHERE firstname like '$search1' OR surname like '$search2'";
$result=mysql_query($query);//run query

//Output results

$numrows=mysql_num_rows($result);	//find numbers of rows

if($numrows>0)//if a result found
{
	while($r=mysql_fetch_array($result))
	{
	echo $r["id"]." ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["email"]." ";
	echo $r["postcode"];
	echo "<br>";
	}
}
else
{
echo "Sorry nothing found";
}
