count(*) arrange by highest value

[dhope]

Hi,

 

is it possible to count how many values where logged on a certain date in a database, then arrange them starting with the the most popular day?

 

Thanks in advance.

 

my code,

 

$query = "SELECT *, count(*) FROM statTracker GROUP by date_visited";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {

}

[Mchl]

SELECT *, count(*) AS logCount FROM statTracker GROUP by date_visited ORDER BY logCount DESC

[dhope]

Thanks