What database are you using? MySQL has a SUM function which automatically selects the total of a column.
-VolVE ----- Original Message ----- From: "JohnP" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 21:25 Subject: Re: [PHP] Average Number For Math Functions > Ok so how do I sum up an entire column in my db? > For example if one row is : 1 , the next is 2, and the next is 1 - I need to > have a total of 4 and the be able to divide by the num_rows > > The problem I ma having is the "inside" row addition > > > > > "Martin Towell" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > just sum them up and divide by the count - making sure to deal with a > count > > of zero > > > > -----Original Message----- > > From: JohnP [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 30, 2002 10:56 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP] Average Number For Math Functions > > > > > > Ok I looked at all the math functions for PHP but saw no way of returning > > the average of a set of numbers - I plan on using this for a rating > system - > > any help? > > > > -- > > John > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
