SELECT type,count(Type) FROM table GROUP BY type这样写能看懂吗~~~
SELECT type,count(Type) FROM table GROUP BY type 什么读取啊?用php
while($all_num = $db->mysql_fetch_array($db->mysql_query("SELECT type,COUNT(type) FROM posts GROUP BY type"))) { echo$all_num; } 不行啊
select count(*) from tablename group by type
while($all_num = $db->mysql_num_rows($db->mysql_query("SELECT type,COUNT(type) FROM posts GROUP BY type"))) { echo$all_num; }
$sql="SELECT type,count(Type) as nums FROM table GROUP BY type"; $result=mysql_query("$sql") while($arr=mysql_fetch_array($result)) { echo $arr["type"]; echo $arr["nums"]; } 这样你应该理解吧..
什么读取啊?用php
{
echo$all_num;
}
不行啊
{
echo$all_num;
}
$result=mysql_query("$sql")
while($arr=mysql_fetch_array($result))
{
echo $arr["type"];
echo $arr["nums"];
}
这样你应该理解吧..