<?include "conninfo.php";

$query="SELECT * FROM staff ORDER BY surname" or die("no");
$result=mysqli_query($link,$query);?>
<h2>Current SOAC staff</h2>
<?
while($r=mysqli_fetch_array($result))
{?>

<img src="images/<?echo $r["photo"];?>" align="left" width="100">
<?
echo $r["firstname"]." ";
echo $r["surname"]."<br>";
echo $r["course"]."<br><br><br><br><br><br><br>";
}