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