Options in menu works for only one product

This is a continuation of a thread/ticket I opened 1 year ago that was closed,
but never resolved. I never closed the ticket, and the last post to the thread was in response to a question. Also one ticket in my account was mistakenly sent to me. Can u delete that ticket from my history?
Problem: I can only get the size list/menu to work for the first product
in my database.

With the DataAssist product detail page,
the menu displays all 4 size options and successfully passes price
to the shopping cart. However, the description in the cart is always
for the smallest size.

On the product detail page that I created (not using DataAssist)
everything is the same as above, but the price for each size increment
is not being passed to the cart, and the price is always
for the smallest size.

Here is the .sql zip file for my database set up,
and the zip file for my product detail page(not done with dataAssist.

How do I get options to display for all products and passed to the cart along with cart description? Thanks
William

When I test out your page with your data I can see that whatever ID is in the URL is the item that will be selected and added to the cart. For the price of the item you are just binding to the price from the recordset, $row_rsDetail['ProductPrice']. I can see that you are adding a size and sizePrice from different recordsets. It seems that you must be adding the additional price with a calculation of some type. I do not have your cart files though so I do not have the calculation that you are using to add the sizePrice to the price.

When I test it out like it is currently I can see the item change with the id, then when I add the item to the cart the item is added according to the id specified. I tried this with three different items and was able to get them to all show in the cart without issue.

I also noticed that out of the items I tested, 1, 2, and 20 only 2 had size selections available for it.

Eric, I used the Product Option tutorial and substituted run-time values with my recordset. I only used the size option. I created the rsSize and rsLookup recordsets and I used the SQL script provided for each.

I realize that only one product (Threegether, the second one) gives me all size options in the list menu. I need to know why the rest won't. The list menu will only pass one price into the cart when there are 4 sizePriceInc 0,50,100,150 base price of $49. 9x9=$49, 16x16=$99, 24x24=$149 and 36x36=$199 The "calculations of some type" are from the Product option tutorial.

Question: How do I set up a product_detail page to display a product such as a T-Shirt with an options list/menu, and also show 3 or 4 other products with image thumbs that could go with the T-Shirt such as shorts and pants? When this additional product thumbs are clicked, they would link to product detail page. I don't know how to display thumbnails/productID's from 2 or more recordsets on the same page.


I'm so curious as to why tutorials for such fundamental functionality necessary fro ALL ecommrce sites, are not front and center, in complete detail for each type of database (asp, cold, mysql)

I've included zip files for the complete site and database sql

I have opened a ticket for you on this issue so that we can look into this further. To update the ticket login and visit your support history.

supporthistory.php

We were able to get the page working. There was not one single issue, most of the recordset code and the way the detail page was setup needed to be redone. Once the recordsets were properly crafted to get the correct values and the form was submitting the correct values it seemed to work as it should.