Adding Up Multiple Rows

[olygolfer]

Hi Again All.

Need some help i am creating a reward points scheme for my site, the problem is I am not sure how to add multiple select rows together. For Example

1.

The mysql select query gets two products from the database and then wrights them to the page using the while () statement

so

$query = "Select product, rewardpoints from productsordered where orderid = ".$order."";

$result = mysql_query ( $query ,$db);

while ($myrow = mysql_fetch_array($result))
{
echo $myrow["rewardpoints"];
}

2.

This would print for example

intel 2222

samsung 3323

3. I am looking to add a rewards point total to this page but am not sure how to go about adding each rewardpoints variable.

ANY IDEAS THANKS

[diego25]

Add a variable inside the loop that will keep track of the total:

$total = 0;
while ($myrow = mysql_fetch_array($result))
{
echo $myrow["rewardpoints"];
$total += $myrow["rewardpoints"];
}

And then outside the loop you just print $total out.

Diego