DaniWeb Forum Index > Web Development > PHP

How do I add up all values of rows in a table???

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Dec 2007

Posts: 136

Reputation: justted is an unknown quantity at this point

Solved Threads: 2

justted

Offline

Junior Poster

How do I add up all values of rows in a table???

Aug 6th, 2008

Hello,

I was wondering if anyone could help me as I am trying to add all the rows of a particular field in a MySQL table using PHP.

I have a table named members2 which has a field named points! What I want to be able to do is display the total number of points currently in the site that all members have!

But I have no idea how to do this and cannot seem to find anything when googling it!

Any help is much appreciated!

Justin

•

Join Date: Aug 2007

Posts: 570

Reputation: ryan_vietnow is an unknown quantity at this point

Solved Threads: 71

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: How do I add up all values of rows in a table???

Aug 6th, 2008

you can try something like this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query="Select points from members2";
$result=mysql_query($query);
 
$total=0;
while($row=mysql_fetch_array($result))
{
$total=$total + $row['points'];
}
 
echo "Total is:" . $total;
$query="Select points from members2";
$result=mysql_query($query);

$total=0;
while($row=mysql_fetch_array($result))
{
$total=$total + $row['points'];
}

echo "Total is:" . $total;

http://www.ryantetek.com/

•

Join Date: Jan 2007

Posts: 16

Reputation: mcd is an unknown quantity at this point

Solved Threads: 6

mcd

Offline

Newbie Poster

Re: How do I add up all values of rows in a table???

Aug 6th, 2008

Easier:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query="SELECT SUM(points) AS `total` from members2";
 
$result=mysql_query($query);
while($row=mysql_fetch_assoc($result))
  $total = $row['total'];
$query="SELECT SUM(points) AS `total` from members2";

$result=mysql_query($query);
while($row=mysql_fetch_assoc($result))
  $total = $row['total'];

If you want to limit the sum to certain sets of data, you will have to use the GROUP BY function in mysql. Learning about grouping and its associated functionality will help you avoid a lot of tedious, repetitive coding.

Last edited by mcd; Aug 6th, 2008 at 11:42 pm.

•

Join Date: Aug 2007

Posts: 570

Reputation: ryan_vietnow is an unknown quantity at this point

Solved Threads: 71

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: How do I add up all values of rows in a table???

Aug 6th, 2008

•

Originally Posted by mcd

Easier:
Help with Code Tags

php Syntax (Toggle Plain Text)
$query="SELECT SUM(points) AS `total` from members2";
 
$result=mysql_query($query);
while($row=mysql_fetch_assoc($result))
  $total = $row['total'];
$query="SELECT SUM(points) AS `total` from members2"; $result=mysql_query($query); while($row=mysql_fetch_assoc($result)) $total = $row['total'];
If you want to limit the sum to certain sets of data, you will have to use the GROUP BY function in mysql. Learning about grouping and its associated functionality will help you avoid a lot of tedious, repetitive coding.

much easier:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query="SELECT SUM(points) AS `total` from members2";
$result=mysql_query($query);
$total=mysql_result($result,0,"total");
$query="SELECT SUM(points) AS `total` from members2";
$result=mysql_query($query);
$total=mysql_result($result,0,"total");