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

$query="SELECT * FROM people WHERE  $field like '$searchcontent'";

$result=mysqli_query($link,$query);

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