php循环嵌套的问题

<?
mysql_select_db($database_cnn, $cnn);
mysql_query("set names 'gbk'");//这就是指定数据库字符集

$officesql = "Select bm,name FROM Office order by id ";
$officequery = mysql_query($officesql,$cnn);
//将这一条
//$a = mysql_query("select bm,name from food order by bm",$cnn);

while($office = mysql_fetch_array($officequery)){
echo $office['name'];
//放到这儿试试
$a = mysql_query("select bm,name from food order by bm",$cnn);
while($ars = mysql_fetch_array($a)){
$sql ="select sum(foodorder.foodnum) from foodorder,member where foodorder.user=member.user and member.office = '".$office['bm']."' and foodorder.foodbm = '".$ars['bm']."'";
$query = mysql_query($sql,$cnn);
$c =mysql_fetch_array($query);
echo $ars['name']."| ".$c[0];
}
echo "<br>";

}
?>