View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

SQL for Options

Thread began 11/11/2009 3:54 pm by steven348539 | Last modified 11/18/2009 2:55 pm by steven348539 | 1938 views | 10 replies



Sorry I haven't made myself clear. I've attached the small amount of data I've placed in the sizes table.

My thinking was, and as I said before if it's wrong you are welcome to correct me, that I have a column in the items table that relates to SizeCatID. So let's say an item has a 2 in the SizeID Column. In the sizes table, a 2 means that there is an 8x10 print for $15.00 available and a 16x20 print for $60.00 available.

Another item might have a 1 in the SizeID column, which means that only an 8x10 for $15.00 is available. (an 8x10 may not always be $15.00 which is why I'm listing a price in the table as well)

So, my idea was that whatever the ItemSize value was for an item it would then generate a drop box that listed all the options that were available for that Category based on the sizes table. I may be wrong as I'm not familar with SQL so I may have to change the tables around, which is fine. I want the most effective method and if I was wrong, well, wouldn't be the first time :lol:

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...