Averaging Numbers
| From: | Jeff Oien | Date: | Wed, 15 Aug 2001 16:41:09 +0000 |
| Subject: | Averaging Numbers | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11382@lists.php.net to get a copy of this message | ||
I'm having a hard time learning how to get an average. I have a database
that gets a number and inserts in into a MySQL database every 1/2 hour
during the day. For the current half hour, I want to get the last 15 days
numbers for the same time as the time it is now. I can retrieve and display
the numbers fine, I just don't know how to go about putting these all into
variables or an array or if I can do this within a query and then take an
average for them. Hope that made sense. Thanks.
Jeff Oien