Re: [ethan76] Results from all tables?
Hi Ethan,
Try creating a single page section called "Specials" with 3 pulldown list fields. One pulldown field for each product section.
In the field editor under "List Options" select "Get options from database (advanced)". Then choose the product table you want, the "num" field for the value, and the product name field for the label.
This should give you three pulldowns in the special section, one for each product section.
See if you can get that far and then let me know. The next step after that is to have it output the 3 selected product numbers on the page, and then add 3 blocks of viewer code to load each individual selected product by specifying the product number in the where. Like this:
where => "num = '{$specials['selectedProduct1']}'",
See how far you can get with the first part and then we'll take it from there and walk you through the rest.
Hope that helps! Let me know if you need more details on any of that!
Dave Edis - Senior Developer
interactivetools.com