mysql fetch - add <br /> after every six rows
Posted: Thu Feb 04, 2010 5:34 pm
How do I add '<br />' after every six rows?
Code: Select all
while($f = mysql_fetch_array($q)) { }A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
while($f = mysql_fetch_array($q)) { }Code: Select all
$q = "SELECT field FROM table";
$result = mysql_query($q);
$breakRows = 6;
$i = 0; //counter
while($row = mysql_fetch_array($result)){
echo $row['field'];
if (($i % $breakRows) == 0) {echo "<br />";}
$i++;
}