How to calculate all data from array list from the database

[skima]

I just tried to develop a small e-commerce site, i used database to store the shopping information for a paticular customer... BUt i need to calculate the total price order a that particular time.


i was able to fetch the particular product but need to calculate the total cost can anyone help me out.

example:

$sql=$cc->query("SELECT * FROM temp_order where uname='$uname' ");

while($fet=$cc->fetch($sql)){

$user=$fet['uname'];
$product_price=$fet['product_price'];

User                Price
$uname          $product_price
}
 
                     Total:(??);//need to get the total here. 

[siteguru]

SELECT *, SUM(product_price) AS Total FROM temp_order where uname='$uname'

[r937]

not quite right, ian, since with all those non-aggregates (the evil "select star") you are missing the GROUP BY clause

skima, what does "fetch the particular product" mean? if there's only one product, why do you need to compute a total? does this imply that there is actually more than one product? and if you do require details (i.e. more than one product), then why couldn't php be used to calculate their total? or do youi want just the total and not the products?