使用PHP输出MySQL查询使用COUNT（*）[重复]

Question

Possible Duplicate:
mysql count into PHP variable

I have the following query that returns successfully when run from MySQL command prompt:

SELECT `from_email`, COUNT(*) 
FROM `user_log` 
GROUP BY `from_email` 
ORDER BY COUNT(*) DESC

This query returns a result set that has the following columns

`from_email` | COUNT(*)

My question is, how do I go about iterating through the result sets and outputting the results. I have my table formatted I just need from_email in one table cell and the associated COUNT in another for each record.

Thanks in advance

Answer 1

add an ALIAS on it

SELECT `from_email`, COUNT(*) AS totalCount 
FROM `user_log` 
GROUP BY `from_email` 
ORDER BY totalCount DESC

and you can now fetch the value

 $row["from_email"]
 $row["totalCount"]