[SOLVED] Loop Problems

[dhorn]

I have this code that uses nested loops to display tables, and populate them from a mySql database, but as of now..when it executes it displays a blank item if the sql table is empty, and I would prefer if it didn't. What would be the best method to solve this problem. Here is the code:

 

  <?php do { 
	$query_info = "SELECT * FROM info WHERE course = ". $row_categories['id'];
	$info = mysql_query($query_info) or die(mysql_error());
	$row_info = mysql_fetch_assoc($info);
  ?>
    <table border='1'>
      <tr>
        <th colspan='3' class = 'head'><?php echo $row_categories['name']; ?></th>
      </tr>
      <tr>
        <th>Item</th>
        <th>Name</th>
        <th>Delete?</th>
      </tr>
      <?php do { ?>
        <tr>
          <td align="center"><?php echo $row_info['item']; ?></td>
          <td align="center"><?php echo $row_info['first_name'];?></td>
          <td align="center"><input type='checkbox' name='checkbox[]' id='checkbox[]' value='<?php echo $row_info['id']; ?>'></td>
        </tr>
        </td>
        
        <?php } while ($row_info = mysql_fetch_assoc($info)); ?>
    </table>
    <br />
    <br />
    <?php } while ($row_categories = mysql_fetch_assoc($categories)); ?>

[rhodesa]

just use regular WHILE loops instead of DO/WHILE:

 

  <?php while ($row_categories = mysql_fetch_assoc($categories)) { 
      $query_info = "SELECT * FROM info WHERE course = ". $row_categories['id'];
      $info = mysql_query($query_info) or die(mysql_error());
      $row_info = mysql_fetch_assoc($info);
  ?>
    <table border='1'>
      <tr>
        <th colspan='3' class = 'head'><?php echo $row_categories['name']; ?></th>
      </tr>
      <tr>
        <th>Item</th>
        <th>Name</th>
        <th>Delete?</th>
      </tr>
      <?php while ($row_info = mysql_fetch_assoc($info)) { ?>
        <tr>
          <td align="center"><?php echo $row_info['item']; ?></td>
          <td align="center"><?php echo $row_info['first_name'];?></td>
          <td align="center"><input type='checkbox' name='checkbox[]' id='checkbox[]' value='<?php echo $row_info['id']; ?>'></td>
        </tr>
        </td>
       
        <?php } ?>
    </table>
    <br />
    <br />
    <?php } ?>

[dhorn]

I tried using regular while loops, but for some reason the loops skipped the first items in the table. For example, if I use regular while loops, the page only displayed the last 4 out of 5 tables.

[rhodesa]

ooops...forgot to add...remove the single fetch_assoc()s:

 

      $row_info = mysql_fetch_assoc($info);

[dhorn]

Yep, that was the key. Thanks for the help!