mysql perform math in the same query as COUNT

[viveleroi0]

Essentially, I am using a basic SELECT field, COUNT(*) FROM table GROUP BY field query, but I want to display a table with the counts - but also with their percentage of the total.

But I have to wait until the end of the row loop to know what all of the COUNT results added together equal. Then I have to create another loop to go through the counts again.

Is there a way I can SUM the COUNT results in the same query?

[nemonoman]

No: two queries will be needed, but you can do the math in SQL in the second query:

$row=my_sql_fetch_array(mysql_query("SELECT count(*) FROM table"));

$result=mysql_query(
"SELECT count(), count()/$row[0] FROM mytable GROUP BY myfield");

etc.