<?include "conninfo.php";
$searchcontent=$_POST["search"];
$field=$_POST["searchtype"];

if($field==1)//First name selected on the radio button
{
$query="SELECT * FROM people WHERE firstname like '$searchcontent'";
}

if($field==2)
{
$query="SELECT * FROM people WHERE surname like '$searchcontent'";
}

if($field==3)
{
$query="SELECT * FROM people WHERE favfood like '$searchcontent'";
}
//echo $query;
$result=mysqli_query($link,$query);

while($r=mysqli_fetch_array($result))
	{
	echo $r["id"]." ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["favfood"]." ";
	
	}

