Page 1 of 1

mysql fetch - add <br /> after every six rows

Posted: Thu Feb 04, 2010 5:34 pm
by JKM
How do I add '<br />' after every six rows?

Code: Select all

while($f = mysql_fetch_array($q)) { }

Re: mysql fetch - add <br /> after every six rows

Posted: Thu Feb 04, 2010 6:28 pm
by manohoo
Something like this could work:

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++;
}

Re: mysql fetch - add <br /> after every six rows

Posted: Fri Feb 05, 2010 3:20 pm
by JKM
Hmm.. $breakRows = 5; $total_rows = 10;, but it adds a <br /> after row1 and row6.

Re: mysql fetch - add <br /> after every six rows

Posted: Fri Feb 05, 2010 3:22 pm
by xjake88x
Set the i to 1 first.