How to calucate and display a total

Davidc316

Hi ho,

I'm finishing up a very simple shopping cart program and on the "view your cart" page I have a table that displays the columns; Item(s), Quantity, Price, Shipping and Total Price.

It's all standard stuff and I'm sure you've seen it all before.

So if a person buys 4 apples at $5 each, then there would be a row which reads;

Apples 4 5 2 22

...that's assuming there is a $2 shipping charge.

So, that's ok so far and all is well. But the trouble is... I'm wondering how to calculate and display a grand total at the very bottom of this table. This grand total value would add up all the "Total Price" values that have been collected when someone buys lots of apples, oranges, bananas and so on.

The main problem here is (I think) the fact that there is no "Total Price" column stored in any of my mysql database tables. That's because "total price", remember, is calculated from the cost of the individual item multiplied by the shipping cost for that item (both figures obtained from MySQL). So, although Item price and Shipping may be in MySQL, Total Price is not.

Can anyone point me in the right direction and tell me how to calculate and display a grand total?

sivasankari_kv

i've done something like this before , i create the visit id when someone enters my site , as the vistor adds things to the shopping cart i add the session id , item no , qty and price in my table once he's done , i don't store the total price per order in any of my tables , when the order is realised i do a simple query and calculate the total count say like this

select sum( price * qty ) as total from cart where session_id = 1;
based on the place to dispatched i pick up the shipping charge i add it to my total and display , Hope it helps , may be ur problem is much more bigger then i've interpreted

Davidc316

Ok thanks for that.

But could someone please tell me the code for that.

Every time I try even a basic select sum command, I keep getting weird answers like "resource ID=3".

The basic command I've been trying is:

$get_grand= "select sum(sel_item_qty ) as total from store_shoppertrack where session_id = '$PHPSESSID'";

But of course that's just a basic test run because the real grand total that I want to calculate would come from two tables- I was get ITEM PRICE and SHIPPING from a table called "store_items" and I would get QUANTITY and $PHPSESSID from a table called "store_shoppertrack". I need some way of using these four variables to get the grand total.

Could someone please help me out with this one? I'm at a complete dead end here.