You can't get the average and a count in the same query
Sure you can. mysql> select count(number), avg(number) from numbers;
Depends how you interpret his request, I guess. I took it as a request for the count of records per day and then the average of those counts.
So, if you had
D1 D1 D1 D1 D2 D2 D3
The count would be
D1 - 4 D2 - 2 D3 - 1
and the average would be (4+2+1)/3 = 2.333. Can you get that in one query?
depends what the OP was after, though...
---John Holmes...
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
