[SOLVED] Adding results.

[DJTim666]

I need to add a bunch of results coming from a DB. I tried doing a simple while statement with a plus sign, but that failed because all it's doing is echoing all the numbers =O!

 

Code:

<?php
while ($rowpageviews = mysql_fetch_array($pageviews)) {
$additup = ++$rowpageviews['pageviews'];
echo $additup;
}
?>

 

All thats dfoing is echoing all the number's in the DB. Any suggestion on how to add them together?

 

--

DJ

[MadTechie]

use this SQL statement

SELECT SUM(pageviews) as TotalPageViews FROM table;

 

and pull this

$rowpageviews['TotalPageViews'];

 

it should be quicker

[DJTim666]

err, you confused me there. Am I still using the while statement, or do I just need a mysql_fetch_array?

[DJTim666]

Nevermind, I figured it out. Thnx for the help !

[MadTechie]

ok

you currently have some code with an SQL statement

 

now instead of using a loop, to add it up

while ($rowpageviews = mysql_fetch_array($pageviews)) {
$additup = ++$rowpageviews['pageviews'];
echo $additup;
}

 

if you change the SQL statement to

SELECT SUM(pageviews) as TotalPageViews FROM tablename;

(your need to update the tablename)

then

$rowpageviews = mysql_fetch_array($pageviews)

echo $rowpageviews['TotalPageViews']; //<--echos the total

 

make sense ?

 

option2

 

change

	$additup = ++$rowpageviews['pageviews'];

to

	$additup = $additup+$rowpageviews['pageviews'];