Adding the contents from a database

[bschwarz]

I want to get a whole bunch of items from the database and add the price together, the records are pulled from the database with something like:

$query = "SELECT order_id, username, status, title, id, price FROM cart WHERE username='$_SESSION[user]' ORDER BY id ASC";

so I want to add the price's togeher at the end of the page, I can't get it through my head though?

Thanks in advance.

[HalfaBee]

How about adding SUM(price) into your select.

HalfaBee

[HalfaBee]

For ease you will probably want to do this as a seperate query.

Or you could just add the total up as you go thru the data

while( $row=mysql_fetch_assoc( $result ) ) {
    $total += $row['price'];
}

HalfaBee