Re: FN-FORUM: Wednesday plea for help with MySQL

date posted 18th January 2007 11:59

Hi Duncan

So you are basically picking from many options. I don't understand why
checkboxes would not be sufficient. The only reason I can understand for the
two box method is when the number of variants is huge, in which case you may
categories and use three multiple selects.

As for storing the selection, would not a table structure something like this
be sufficient.

Order
orderid (pri key)
...

Order items
orderid
productid
orderitemid (pri key)
...

Varients
orderitemid (foreign key to orderitems)
varientid (foreign key to varients)

Or am I missing something?

On Wednesday 17 January 2007 10:59, Duncan Glendinning wrote:
> Hi there,
>
> Right, well how silly am I?
> The problem I am having is in implementing the second part of the
> system. I have got the first part sorted, whereby (via the admin) the
> products, variants, lists can be set up, and allowed variants assigned
> to each of the lists.
> What I can't figure out how to do is the front end part, with the two
> lists with two buttons for each list, and the database tables needed
> to store what they have selected from each of the lists.
>
> Sorry about that!
>
> Duncan

--
Artumi Systems, 58 Salmon Street, Sheffield, S11 8DD.
Tel 0114 250 7654, Web http://www.artumi.com