<?include "conninfo.php";
print_r($_POST);

$thesearch=$_POST["thesearch"];
$choice=$_POST["choice"];

//echo $thesearch;
//echo $choice;

if($choice=='fn')
{
	$query="SELECT * FROM people WHERE firstname like '$thesearch'";
}
else if($choice=='sn')
{
	$query="SELECT * FROM people WHERE surname like '$thesearch'";
	
}
else{
	$query="SELECT * FROM people WHERE favfood like '$thesearch'";
}
$result=mysqli_query($link,$query);

while($r=mysqli_fetch_array($result))//get row
	{
	echo $r["id"]."  ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["favfood"]." ";
	echo $r["starsign"]."<br>";
	}
?>