$sql="select department,count(*) from roscoe group by department";
$d=mysql_query($sql);
$row=mysql_fetch_row($d);
怎么写$row得到的是2维数组,我这只能得到最后一组数据,...
foreach($row as $number){
foreach($number as $ss){
echo $number."有".$ss."人";
}
}
理想的是输出department名字,和他的count(*)的数字!
怎么写,我这方法错的,
while($row=mysql_fetch_row($d)){
echo $row['0']."有".$row['1']."人";
}
才搞成功了...
|