PHP Nested Loop Tutorial

I guess since you are looking for a nested loop "solution" you already familiar with a simple database structure used in this method.



Open DW, create a table.

Create a recordset named "menu" to show only PARENT menu items which have SID value "0":

Insert dynamic text for MENU name field.

Create another Recordset and name it "submenu".
Note the SID equals $row_menu['id'], we will modify this later in the code view.

Create a second table under the first one, insert the Dynamic text from SUBMENU "menuname" Recordset and apply REPEAT REGION to both tables.

Now go to CODE VIEW and place the Recordset "submenu" under the closing </table> tag of the parent menu item table.
Look into the query where we typed earlier $row_menu['id'], we need slightly to change it.
Replace: $query_submenu = "SELECT * FROM menu WHERE sid = $row_menu['id']";
With: $query_submenu = "SELECT * FROM menu WHERE sid =".$row_menu['id']."";

This procedure could me much "cleaner" but i won't complicate things.
Dont forget to apply <?php tags ?> :)

Now we will loop the second table.
Type in repeat manualy, Dreamweaver will "complain" if you try to do it in design view.

<?php do { ?>
YOUR SECOND TABLE
<?php while ($row_submenu = mysql_fetch_assoc($submenu)); ?>

Next we are going to....hey, thats it!!!