Nested loop won't work

Why won't this work? I want a list to loop within a looped list from another db table... Looks logical for me, but dataassist won't handle it. Any clues?

<?php do { ?> <p><?php echo $row_rsMin['Title']; ?></p>

<?php do { ?>
<p><?php echo $row_rsSubmin['Title']; ?></p>
<?php } while ($row_rsMin = mysql_fetch_assoc($rsMin)); ?>

<?php } while ($row_rsMin = mysql_fetch_assoc($rsMin)); ?>

not quite sure what your trying to accomplish with this, but both loops are using the same recordset try changing it to:
<?php do { ?> <p><?php echo $row_rsMin['Title']; ?></p>

<?php do { ?>
<p><?php echo $row_rsSubmin['Title']; ?></p>
<?php } while ($row_rsSubmin = mysql_fetch_assoc($rsSubmin)); ?>

<?php } while ($row_rsMin = mysql_fetch_assoc($rsMin)); ?>

Here is my file. I just don't know if I'm missing braces or parentheses or what??

Can you give a brief description of how the code is behaving versus what you are expecting so I can get a better understanding of what is wrong.

Well... The outside loop works, but the inside loop only works the first time that the outside loop executes. Then ... the outside loop continues to give correct results without the corresponding results from the inside loop.

Example:

outside result 1
inside result 1
inside result 2
inside result 3
Outside result 2
inside results are missing
Outside result 3
inside results are missing
Outside result 4
inside results are missing

Did you see my reply?

That is how I would expect the loop to act given the way it is coded.


If you are trying to show inside result records that are related to the currant outside result, you will need to add the recordset for inside results inside the outside results loop, before the inside results loop. For example:

<?php do { ?> <p><?php echo $row_rsMin['Title']; ?></p>



[-- Create rsSubmin Here --]



<?php do { ?>

<p><?php echo $row_rsSubmin['Title']; ?></p>

<?php } while ($row_rsSubmin = mysql_fetch_assoc($rsSubmin)); ?>



<?php } while ($row_rsMin = mysql_fetch_assoc($rsMin)); ?>

I will try that. Thank you!

you're welcome.