高手帮忙:select username,COUNT(username) as num from userlist group by username order by num desc
$sql="select username,COUNT(username) as num from userlist group by username order by num desc";
$result=mysql_query("$sql")
while($arr=mysql_result($result))
{
echo $arr["username"];
}
说明:userlist表中字段username不唯一,简单说,我想搜索username的行的数量,然后从多到少的列出username
(样式这样:
admin 10(说明admin在userlist中一共有10行数据)
elon 8
..... )
这个语句:select username,COUNT(username) as num from userlist group by username order by num desc
在phpmyadmin下完全正确,可在写语句的时候,就取不到数据了!
请问有什么好方法?解决问题就结贴!!!