<?
include "conninfo.php";

$query="SELECT * FROM people,jobs WHERE jobtitle=jobid 
AND fname like 'G%' ORDER BY fname";

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

while($r=mysqli_fetch_array($result))
{
echo $r["fname"];
echo " - ";
echo $r["jobname"]."<br>";
	
}




?>