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 <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 # > # [EMAIL PROTECTED] | +46 704 86 14 92 # > # ICQ: 63006462 | +46 8 694 82 22 # > # PGP: http://www.mindbash.com/pgp/ # > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
