"; $sql = "select * from Staff where Staff_Cat = '".$Staff_Cat."' order by Staff_OrderID, Staff_Name" ; $result = mysql_query($sql); if (!$result) {echo "FAILURE TO QUERY";exit;} $numrows=mysql_num_rows($result); if ($numrows>0) { $PerRow=3; echo ""; echo ""; for ($k=0;$k<$numrows;$k++) { $row=mysql_fetch_row($result); $Staff_ID=$row[0]; $Staff_Cat=$row[1]; $CATsql = "Select SCat_Title FROM SCategory where SCat_ID = ".$Staff_Cat ; $CATresult = mysql_query($CATsql); $CATrow=mysql_fetch_row($CATresult); $Staff_Cat_Title=$CATrow[0]; $Staff_Name=$row[2]; $Staff_Bio=$row[3]; $Staff_Email=$row[4]; $Staff_OrderID=$row[5]; $UploadImage = ""; if (file_exists ( "images/staff/".$Staff_ID.".jpg")){$filename="images/staff/".$Staff_ID.".jpg";} else{$filename="images/staff/na.jpg";} if ($k>0 && $k/$PerRow==intval($k/$PerRow)){echo "

".$Staff_Heading."

";} echo ""; } echo"

"; if ($Staff_Email){echo $size."".nl2br($Staff_Name)."";} else {echo "".$size.nl2br($Staff_Name)."";} echo "

"; } ?>