<?include "conninfo.php";

$job=$_POST["job"];

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

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

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

