close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Size and Color charts

Thread began 8/23/2010 3:59 pm by bill173836 | Last modified 8/25/2010 1:20 pm by Jason Byrnes | 1828 views | 21 replies |

bill173836

Size and Color charts

I've created a style, size and color matrices and I want to get the chosen values into the orderdetails table. I've added the proper fields...DetailStyle, DetailSize & DetailColor.

I've also created 3 tables for the style, size and color options. I created 3 additional columns in my ecart object where each is an id integer. The id for each corresponds to the style, size and colors available for the product.

My problem is:
Instead of choosing the lets say v-neck of a list of 3 styles.
Small in a list of 5 available sizes.
Black in a list of 3 available colors.

I'm getting the id of the list that is stored. I want to store V-neck, Small & Black instead.
How would I do this?

Sign in to reply to this post

Jason ByrnesWebAssist

in the drop down lists for the options, set the values to use the name column instead of the id column

Sign in to reply to this post

bill173836

The pull down is showing up fine.
Here is what I'm getting:
productcolormatrix - database table
colorID colorGroupID color
1 1 White
2 1 Black
3 1 Blue
4 1 Gray
5 2 Pink
6 2 Green

For the list I'm sorting my colorGroupID where all the 1s are grouped.
The list shows up fine but if i were to choose Blue as my color option a 1 is inserted into the ordersdetail table in the color field instead of Blue. I want to grab and insert the color name instead of the colorGroupID.
Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

when you create a select list option, there are two parts, the value and the label.

the label is what is displayed to the user, the value is what is posted with the form.

Change the value to use the name column just like the label.

Sign in to reply to this post

bill173836

That's what I'm doing. The pull down looks fine. It's just not inserting the name in to the database when the checkout is submitted. It's inserting the colorGroupID instead.

Sign in to reply to this post

Jason ByrnesWebAssist

can you post a copy of your page.

Sign in to reply to this post

bill173836

store.php

Sign in to reply to this post

Jason ByrnesWebAssist

please add the store.php page to a zip archive so i can examine the code.

Sign in to reply to this post

bill173836

Here ya go.

Attached Files
store.php.zip
Sign in to reply to this post

Jason ByrnesWebAssist

in the add to cart button, set the Color, Size and Style column to be updateable from a select list. This will have eCart create select lists on your page use these select lists instead of the ones you created.

Set them to use the recordsets that exaist on your page already, this will pass the form velues to the cart.

Sign in to reply to this post
loading

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

Content

rating

Layout

rating

Ease of use

rating

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...