<?include "conninfo.php";
include "banner.php";

$query="SELECT * FROM people,joblist,starsignlist 
WHERE job=jobid 
AND star=starid";   //set up query
$result=mysql_query($query);	//run the query

while($r=mysql_fetch_array($result))
{
echo $r["id"]." ";
echo $r["firstname"]." ";
echo $r["surname"]." ";
echo $r["email"]." ";
echo $r["postcode"]." ";

?>

<img src="images/<?echo $r["image"]?>" width="100">

<a href="<?echo $r["favlink"];?>"></a>

<?
echo $r["jobname"]." ";
echo $r["starname"];
echo "<br>";
}


?>