[Resolved] Totalling a Price Column

[SlimJimmy]

Trying to extract and echo out the Total Value of Prices in a Database relating to a User.

The code below is only echoing out the last row entry for a given user....

$str_SQL = "SELECT * FROM basket WHERE user = '".$_SESSION['thisuser']."'";
$resulttotal = $db->query_db('mydb',$str_SQL);
if(mysql_num_rows($resulttotal)>0)
{
while($rows = mysql_fetch_array($resulttotal))
{
$theprice=$rows['price'];
$totalprice=$theprice;
}
}
echo ''.$currencysymbol.' '.$totalprice.'<br>';

Any Help appreciated, it's driving me nuts...

[LordShryku]

# change
$totalprice=$theprice; 
# to
$totalprice += $theprice; 

[SlimJimmy]

Thanks M8, I knew it would be straightforward, it's just finding the wood in the tree's.

Forever Grateful

[ayzee]

Better solution:

Replace your SQL with this:

$str_SQL = ("
SELECT DISTINCT user, SUM(price) AS totalprice FROM basket
WHERE user = '".$_SESSION['thisuser']."'
GROUP BY user");

This way the mySQL server does all the math before returning the result to you.

[SlimJimmy]

WOW, Cheers M8 - Im comin here again.

Thanks ayzee I'm stunned