"GROUP BY" Help

[Anon]

This may be simple, but I've not done this before, and I've read the mySQL doc and still can't find the answer.

I'm using the following SELECT statement:

$result = mysql_query("SELECT fld_hour, count(*) AS IMPRESSIONS FROM site_stats GROUP BY fld_hour");

When I type this at the mySQL command, I get the result I want - IMPRESSIONS showing the value of 10, but I need to extract that data using PHP and display it, but I can't find any way to do it? Anyone provide with a solution?

Thanks in advance

[jjoske]

You have to to retrieve the results.
Try the following code:
while($row=mysql_fetch_row($result) {
print"$row[0] $row[1]";
}

[Anon]

Hmm, ok just realised I've not made myself clear 🙂

I want to count the number of rows held within the group.