<?include "conninfo.php";//connection
$search=$_POST["search"];//get from form

$query="SELECT * FROM people,jobs WHERE people.job=jobs.jobid AND surname like ?";

	
$stmt=mysqli_stmt_init($link);//link to database
mysqli_stmt_prepare($stmt,$query);//prepare query

mysqli_stmt_bind_param($stmt,"s",$search);
mysqli_stmt_execute($stmt);

$result=mysqli_stmt_get_result($stmt);

$numrows=mysqli_num_rows($result);//how many rows found?

echo "Records found: ".$numrows."<br><br>";

if($numrows>0)//if there were some rows, print out
{
	while($r=mysqli_fetch_array($result))
	{
	echo $r["id"]." ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["favfood"]." ";
	echo $r["jobname"]."<br>";
	}
}
else
{
	echo "Sorry! Try again!";
}



?>