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

Thanks

paulnaj

Assuming it's sql you need, here's an example:

SELECT SUM(myAmount)
FROM myTable
WHERE myID = 5
GROUP BY myID

See how you get on adapting this.

rocket

could you break this down and tell me what each thing does
Thanks

paulnaj

Probably more useful if you look up each of the terms in the mysql manual and see how you get on first.
Post back once you've had a go.

rocket

all i need to know is what does the "5" do

rocket

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!!";
};}}

paulnaj

The '5' was just an example value for an example 'id' field in the select query.

For your example, you just need to tell mySQL which field to add together ...

SQL = "SELECT SUM(price1) FROM cart WHERE price1='$price56'";

In order to use the aggregate functions (SUM, MAX, MIN, AVG, etc) to produce more than one sum across a range of 'prices' you need to add a GROUP BY clause so that mySQL knows what to sum over.

Hope that makes sense!