Average per day based on num_rows

[Anon]

I have a table with two fields (id and date)

What I need is the number of records for each day.

ex:
2001-12-01 = 10 records
2001-12-02 = 6 records
2001-12-03 = 15 records
2001-12-04 = 3 records
.....

Then take those numbers add them up and divide by the number of days.

Is their an efficent way of doing this with php or sql.

[majik-sheff]

This should do what you want:

SELECT DISTINCTROW Count(ID) AS CountOfID, date FROM mytable GROUP BY date;

[Anon]

That is exactly what I needed I was trying to write some fancy php function.

Thanks

[majik-sheff]

Glad to help 🙂