<?include "conninfo.php";

$mysearch=$_POST["thesearch"];
$myfield=$_POST["thefield"];

if($myfield=="f")
{
$query="SELECT * FROM people WHERE firstname like '$mysearch'";
}
else if($myfield=="s")
{
$query="SELECT * FROM people WHERE surname like '$mysearch'";
}
else
{
$query="SELECT * FROM people WHERE postcode like '$mysearch%'";
}
 
$result=mysqli_query($link,$query);

$nr=mysqli_num_rows($result);
echo $nr." rows found<br><br>";

while($r=mysqli_fetch_array($result))
{
	echo $r["id"]." ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["postcode"]."<br>";
}

