View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Automatic price update with size choice

Thread began 9/06/2009 12:08 pm by segufix361615 | Last modified 9/11/2009 10:15 pm by segufix361615 | 2580 views | 19 replies


Hi Craig,

Thank you for your help.

I spent the last two hours trying to make sense of your post. When it comes to databases I feel like a toddler.

So here is what I understand:

ItemID | Name __ |SizeID
1 ____ | Product a | ?

SizeID | Description
1 ____ | M
2 ____ | L

ItemID | SizeID | Price
1 ____ | 1 ____ | 10.00
1 ____ | 2 ____ | 12.00 (or does the ItemID in this table have to be unique?)

I don't know what to put into the SizeID field marked with the question mark. This is where the customer should make the choice. If I predetermine a value like "1", wouldn't that be just the same as putting the actual size "M" in there?

And to make it a little more difficult our products come in different sizes and versions. Here is an example:
- Product A, Size 1, version a, price=10.00
- Product A, Size 2, version b, price=22.00
- Product A, Size 1, version b, price=12.00
- Product A, Size 2, version a, price=20.00

So, for the table tblprice I could not enter a price, because it would still depend on the version the customer picks.

And here you lost me completely
"On your item detail page, you can query your price look up table which is filtered using sizeid and itemid variables posted from the add to cart form. Then you can pass the price returned from the query into the cart array."

Unless I can click on the lightening bolt I am lost. I have not the faintest knowledge of PHP.

Do I need to hire a specialist? I mean, is there any chance for a beginner to pull this off?

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