56,678
社区成员
发帖
与我相关
我的任务
分享
$query = 'SELECT col,COUNT(*) AS cnt FROM tb GROUPBY col';
$result = mysql_query($query)
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("ID: %s Name: %s", $row["id"], $row["name"]);
}
mysql_free_result($result);
SELECT col,COUNT(*) AS cnt
FROM tb
GROUP BY col;