Re: Doing statistics with MySql data?
| From: | Fred | Date: | Mon, 10 Dec 2001 05:18:27 +0000 |
| Subject: | Re: Doing statistics with MySql data? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-77179@lists.php.net to get a copy of this message | ||
There are built in functions in mysql for just this sort of thing. There
are AVG() and COUNT() functions as well as many more. Read up on them here:
http://www.mysql.com/doc/F/u/Functions.html
Fred
Daniel alsén <d@mindbash.com> wrote in message
news:PGEGIELINOCCEHLENIOJCEBFCDAA.d@mindbash.com...
> Hi,
>
> i have a MySql table with five columns that are filled with different
> numerical values. I need some pointers to where i can learn how to build
> statistics out of this data (ie the average value of a column, how many
> instances there is of a certain value etc).
>
> Regards
> # Daniel Alsén | www.mindbash.com #
> # d@mindbash.com | +46 704 86 14 92 #
> # ICQ: 63006462 | +46 8 694 82 22 #
> # PGP: http://www.mindbash.com/pgp/ #
>