Hi,

The recipe demo lists a series of categories in the Title position and then a vertically scrolling list of recipes in the view page that match that category.

Is this possible from a dynamic point of view (taking the data from a MySql database)?

If so, is there a tutorial and if not can some pointers be made in how to do this?

Mant thanks,

Edited by - John Langer on 23 Jun 2011  15:35:30

Hello John,

The content of the Sliding panels can be whatever you like.

You can create the Sliding panels dynamically as well. Check the Creating Dynamic Sliding Panels Video on the Product Details Page in videos tab.

You will need two record sets for categories - one to make the panels dynamic and one to populate the Home page.

Regards,

Hi, thanks for your help.

Yes, I am aware of that and have completed that tutorial with success.

I'm trying to do something a bit different. Using your recipes demo as an example and placing that in a MySql database:

Table one Categories
Table two Recipes

In the recipes table all there is is a foreign key saying which category that recipe is in (1 or 2 or 3 etc) so how do I get the categories to appear at the top and then the recipes (several of them) for that category to appear in the panel. Is this possible?

Many thanks,

Hello John,

try using nested Recordsets.

You create two recordsets for the Categories - one to be used as navigation and one to repeat for the slides. Inside the second recordset - the one for the slides - set a recordset for Recipes filtered by the category ID that is currently shown.

That is the possible way. However you may need to work it extensively in code view because nested recordsets are not supported by the DreamWeaver Server Behaviors Panel.

Regards,

Many thanks for your reply. I'll try that and see if it works. I think I get the principle :-)

Many thanks once again for your help.