我的桌子上有很多不同班级的学生。我想打印不同的班级一次,并打印该班的学生人数。我可以打印这门课。但无法打印每节课的学生人数。我该怎么做?例如:
In my database: Desired Output:
Class Name Class Num. of Students
2 John 1 2
2 Snow 2 3
3 Jara 3 1
1 Peter
1 Nira
2 Jerin这是我的代码:
$q = "SELECT * FROM ipsc_student group by class";
$rs = mysql_query($q);
$numOfRows=mysql_num_rows($rs);
$rt = "";
$sl = 0;
while($row=mysql_fetch_assoc($rs)){
$sl++;
$rt.="<tr>";
$rt.="<td>$sl</td>";
$rt.="<td>".$row['class']."</td>";
$rt.="<td>$numOfRows</td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="</tr>";
}
echo $rt;发布于 2016-10-30 05:34:34
尝尝这个
$q = "SELECT class, count(*) as NUM FROM ipsc_student GROUP BY class";
$rs = mysql_query($q);
$numOfRows=mysql_num_rows($rs);
$rt = "";
$sl = 0;
while($row=mysql_fetch_assoc($rs)){
$sl++;
$rt.="<tr>";
$rt.="<td>$sl</td>";
$rt.="<td>".$row['class']."</td>";
$rt.="<td>".$row['NUM']."</td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="<td></td>";
$rt.="</tr>";
}
echo $rt;https://stackoverflow.com/questions/40326231
复制相似问题