adding up

[rocket]

ok heres what i am doing i have a table in my data base that has about 35 different rows of data in it(theyare all "int"). what i am doing is i am useing a search script to pull about 5 of those rows out and what i need help with is i need to add all those rows up to give me a total any help would be welcome

Here is my code

$SQL = "SELECT * FROM cart WHERE account='account'";
$retid4 = mysql_db_query($db, $SQL, $cid);
if (!$retid4) { echo( mysql_error()); }
else {
while ($row8 = mysql_fetch_array($retid4)) {

$price56 = $row8["price1"];

$SQL = "SELECT SUM * FROM cart WHERE price1='$price56'";
$retid6 = mysql_db_query($db, $SQL, $cid);
if (!$retid6) { echo( mysql_error()); }
else {
while ($row9 = mysql_fetch_array($retid6)) {

if ($_SESSION["loginid"]==2) {echo "<ul><li>$row9</li></ul>\n";}
else {
echo "Please Login To See Your Shopping Cart!!";
};}}

Thanks

[sarahk]

here's my interpretation of what you want
I'd be inclined to make the 2 queries into 1 though with

$SQL = "SELECT account, price1, sum(*) as sumvar FROM cart WHERE account='account' group by account, price1"; 

but you can play with that once you get this version working.

<?php
if ($_SESSION["loginid"] != 2) 
{
 	echo "Please Login To See Your Shopping Cart!!";
	exit;
}
//must be logged in to get this far
$SQL = "SELECT * FROM cart WHERE account='account'"; 
$retid4 = mysql_db_query($db, $SQL, $cid); 
$sum = 0;
if (!$retid4) echo( mysql_error()); 
else 
{ 
  echo '<ul>';
  while ($row8 = mysql_fetch_array($retid4)) 
  { 
	$price56 = $row8['price1']; 

$SQL = "SELECT SUM(*) as sumvar FROM cart WHERE price1='{$price56}'"; 
$retid6 = mysql_db_query($db, $SQL, $cid); 
if (!$retid6)  echo( mysql_error());  
else 
{ 
	while ($row9 = mysql_fetch_array($retid6)) 
	{ 
		echo "<li>{$row9['sumvar']}</li>\n";
		$sum += $row9['sumvar'];
	}
}
  } 
  echo "</ul><b>Total: </b> {$sum}\n";
}
?>