[thelist] updating db after user alters shopping basket amounts

rudy r937 at interlog.com
Thu Oct 24 05:00:00 CDT 2002


>>    order ---1-to-many --- orderitem --- many-to-1 --- product
>
> I don't think my tables are set up like that.
>
> there is an image table that contains the image's id, its title,
> the date it was photographed, the height and width of the files,
> the amount of times it was viewed, etc.

that's your product table

> then there is the shopping cart table which contains the cart id,
> the users id, the image id, A4 quantity, A3 quantity, other print
> size value and license value.

so, pretty much like that screen grab

okay, so what you have to do is loop through the "rows" of form fields, and
update the cart table for each

rudy




More information about the thelist mailing list