RE: [PHP] MySQL query for average records per day OT

2004-09-16 Thread Jay Blanchard
[snip] mysql> desc dates; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | the_date | date| YES | | NULL| | | number | int(11) | | | 0 | | +--

RE: [PHP] MySQL query for average records per day OT

2004-09-16 Thread Jay Blanchard
[snip] > You can't get the average and a count in the same query Sure you can. mysql> select count(number), avg(number) from numbers; +---+-+ | count(number) | avg(number) | +---+-+ |18 | 2.3889 | +---+-+ 1 r