totals

help again please chaps and chappesses....

ive got a table in the MY BASKET section of my site which shows Item number, name, price per unit, quantity, and total for item (Which is price X quantity).

Now, at the end of my code i have a total value, which adds all the prices together.... thats my problem though.  It adds the prices per unit, not with the quantity too.  Am i being clear?  I only have a PRICE column in my database, not one which does the calculating for me.  I do that on the ASP page.  How do i get it to add all the values together of PRICE X QUANTITY from records which have been filtered in the SQL when the DB opened.

Hope you can help as this is really baffling me now.

Cheers folks,

Matt

Edited by Mattblack - 30 June 2005 at 1:58pm

If you have the price and the quantity stored in the database just return the price, quantity, and price * quantity with your SQL query,

select price, quanitity, price*quantity from ...


than you can add the total of price * quantity togther as listed above. I try to return the data as close as possible to form I need for display as it just take less time overall. Personal, I would just query the database for the total using,

select sum(price*quantity) from ...