repeating regions (mysql)

[pheonix]

I guess a simplified example of what i am trying to do would be: add a line break after every 5th record taken from the database.

<?php do { ?>
<?php echo $row_Recordset1['id']; ?>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

after every 5th $row_Recordset1['id']; i want the script to automatically insert a "<br>"

any help would be really appriecated. i have been looking through the manual and google for a couple hours and i got nothing. so even some key words or tutorials on the subject would be great.

thanks again,
daniel s.

[devinemke]

$result = mysql_query('SELECT id FROM table');
$i = 1;
while ($row = mysql_fetch_assoc($result))
{
	echo $row['id'];
	if ($i == 5) {echo '<br>'; $i = 0;}
	$i++;
}

[pheonix]

that is exactly what i am looking for. that help a bunch. thanks.

daniel s.

[pheonix]

<table width="485px" border="1" cellspacing="0" cellpadding="0">
  <?php
	$i = 1; 
	while ($row = mysql_fetch_assoc($Recordset1)) 
	{ 
		if ($i == 1) {
		echo '<tr>' . "\n";
		} 
		echo "<td>" . $row['title'] . "</td>" . "\n"; 
		if ($i == 3) {
		echo '</tr>' . "\n \n"; 
		$i = 0;
		}
		$i++; 
	}
	?>
</table>

IT WORKS!!! So i needed to make the recordset span multiple columns. Now it does. thank again i posted the code incase anyone is looking for something similar.