Echo the count for each result

SwiftyStylez

New Member
This PHP/MySQL gets the top tweeters from my database:\[code\]$toptweeters = mysql_query("SELECT count(user) a,user from fotetweets group by user order by a desc limit 10"); while ($row = mysql_fetch_assoc($toptweeters)) { echo "<li style='border: 0; margin-left: 5px;'><a target='_blank' style='border: 0;' href='http://twitter.com/".$row["user"]."'>"; echo $row["user"]; echo "</a></li>"; }\[/code\]How can I also display the count result for each of the users returned?
 
Back
Top