<?include "conninfo.php"; //database connection info

$query="SELECT * FROM people,roles WHERE people.job=roles.jobid";

$result=mysqli_query($link,$query);//run query


while($r=mysqli_fetch_array($result))
	{
	echo $r["id"]." ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["favfood"]." ";
	echo $r["jobname"]." ";
		if($r["pic"]!="")
		{?>
		<img src="images/<?echo $r["pic"]?>" width="30">
		<?}
		 
		if($r["link"]!="")
		{?>
		<a href="<?echo $r["link"];?>" target="_blank">Go to website</a>
		<?}
	echo "<br>";
	}

	
?>