Shaun wrote:

Is it possible to combine the COUNT & AVG functions using MySQL? I have a
table called Bookings and I need to find out the average number of bookings.
So I need to count the number of bookings in the table and then get the
Average, is this possible?

Learn SQL, please.

SELECT COUNT(column), AVG(column) FROM table GROUP BY column

---John Holmes...

Amazon Wishlist:

php|architect: The Magazine for PHP Professionals –

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to