[RESOLVED] Help with nested loop

[ChetUbetcha]

Using DW...

I have been trying everything, including Tom Muck's nested repeat region, but I can't get the first element (section) to be the outside loop with the second element (bullet) looping inside. Instead of:

Section 1
- Section 1 Bullet 1
- Section 1 Bullet 2
- Section 1 Bullet 3
Section 2
- Section 2 Bullet 1
- Section 2 Bullet 2
- Section 2 Bullet 3

I'm getting:

Section 1
- Section 1 Bullet 1
- Section 1 Bullet 2
- Section 1 Bullet 3
- Section 2 Bullet 1
- Section 2 Bullet 2
- Section 2 Bullet 3

How do I break out of the first loop after it's bullets are done and then start another loop with a different outer loop?

<table width="100%">
<?php do { ?>
<tr>
<td colspan="3" class="HEADER2">Enter applicable title for bullet sections (i.e. NGI)</td>
</tr>
<tr>
<td valign="top" align="center" width="40" class="bullet"><b>·</td>
<td colspan="2" valign="middle" class="HEADER2"><?php echo $row_bullets['section'];?></td>
</tr>
<?php do { ?>
<tr>
<td align="center" valign="top" width="40">&nbsp;</td>
<td align="center" valign="top" class="bullet2">o</td>
<td valign="middle" class="BULLETtext"><?php echo $row_bullets['bullet'];?></td>
</tr>
<?php } while ($row_bullets = mysql_fetch_assoc($bullets)); ?>
<?php } while ($row_bullets = mysql_fetch_assoc($bullets)); ?>
</table>

[laserlight]

Why is it a nested loop in the first place? It looks like it should be two consecutive loops.

[ChetUbetcha]

<table width="100%">

<?php do { ?>
// this was the start of my 1st loop

<tr>
<td colspan="3" class="HEADER2">Enter applicable title for bullet sections (i.e. NGI)</td>
</tr>
<tr>
<td valign="top" align="center" width="40" class="bullet"><b>·</td>
<td colspan="2" valign="middle" class="HEADER2"><?php echo $row_bullets['section'];?></td>
</tr>


[INDENT]<?php do { ?>
// this is SUPPOSED to be the start of my 2nd loop, with me thinking "since I haven't put the while line in, I should be good to insert/embed another loop before breaking out of the first loop"

<tr>
<td align="center" valign="top" width="40">&nbsp;</td>
<td align="center" valign="top" class="bullet2">o</td>
<td valign="middle" class="BULLETtext"><?php echo $row_bullets['bullet'];?></td>
</tr>

<?php } while ($row_bullets = mysql_fetch_assoc($bullets)); ?>
// this would be the end of my 2nd loop[/INDENT]

<?php } while ($row_bullets = mysql_fetch_assoc($bullets)); ?>
// this would be the end of my 1st loop

</table>

[laserlight]

By the way, why use do while loops? You should use while loops instead, methinks.

[ChetUbetcha]

Any chance The Village Idiot (aka moi) can get an example of how to do this?