Loop Issue

[obrienkev]

Hi all,

I want a new <tr> created each time 5 results are displayed. The next five results then appear on a new <tr>

How do I do this?
Thanks.

if ($num_results > 0)
{
       echo '<table><tr>';
          while ($row = mssql_fetch_assoc($result))
    {
           echo '<td>';
          echo '<a href="index.php?id2='.$row['id'].'">'.$row['name'].'</a>';
       echo '</td>';
        }
        echo '</tr></table>';
}

[bogu]

if ( $num_results >0 ) {
	echo "<table>"; $i = 0;
	while (mysql_fetch_assoc($result)) {
		if ($i%5) echo "<tr>";
		echo "<td>Bla bla ...</td>"; $i++;
		if ($i%5) echo "</tr>";
	}
	/* add the rest of the table cells and close the row*/
	if (($i%5)!=0) {
		while ($i%5) {
			echo "<td></td>"; $i++;
		}
		echo "</tr>";
	}
	echo "</table>";
}

Is not tested, in case of some error u should get the idea ...