<?include "conninfo.php";		//database connection
$searchvalue=$_POST["sn"];		//pick up data from form

$query="SELECT * FROM people WHERE surname like '$searchvalue'";
$result=mysql_query($query);		//run query 
$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";
}

?>