[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 row in set (0.00 sec) [/snip] If it is numbers you can, but the OP wanted to average for dates. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
