View Single Post
Old 10-11-2005, 07:48 PM   #3 (permalink)
BUFFY
Registered User
 
Join Date: May 2005
Posts: 29
BUFFY is on a distinguished road
Ok i'll load what ive got so far (not working) onto my tech server.

When I say I have a site, I mean i have a php page which displays products, that was simple enough.... and I have a idea of how to tackle multiple orders.

(my last site dealt with one product item per order so it was just inserting fields into the order table, whereas this one I need help on).

Temp site here: http://www.bcs.net.nz/~annah/ahidesigns/products.php

I have loaded a couple of pages to this address, click quality prints. Then there are multiple includes for the different categories in the productdetails.php page.

Since you clicked quality prints, that page will be included so the address should be products.php?qualityprints=yes.

Did you want my query code? Just ignore the broken images as I have to change my pages as the query isn't working for some reason there.

The design is "in process"


As you can see, the size, quantity and tickbox are just HTML code that I will insert into my order table. The price depends on the size and quantity so will do some if statements there.

My question is...

How do I make it so that only the products that have the tickbox selected are inserted into the order table, how do I use the orderitem juntion table with the quanity in it for each item ordered?

Hopefully it makes more sense to you know, Im not doing a good job of explaining it because Im not sure my idea on how to tackle it is right.
BUFFY is offline   Reply With Quote