How to add a break point in MySQLi results
Hello,
I have a basic recordset that polls for 9 records that meet a criteria. I'd then like to have the repeat region that displays these results only show them in groups of 3 after which I will put a break <br />
The result is three rows with 3 results in each row.
Basic Recordset polling for 9 records:
<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$minBlog_i,9);
$Recordset1->setQuery("SELECT * FROM news WHERE news.newsType = ?");
$Recordset1->bindParam("i", "".$_GET['id'] ."", "36"); //target
$Recordset1->execute();
?>
Repeat region that shows all records:
<?php
while(!$Recordset1->atEnd()) {
?>
<a href="uploadedImg/<?php echo($Recordset1->getColumnVal("newsImage")); ?>"><img src="uploadedImg/thumb_<?php echo($Recordset1->getColumnVal("newsImage")); ?>" alt="<?php echo($Recordset1->getColumnVal("newsAlt")); ?>"/></a> <br />
<?php
$Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
?>
I expect this will take a looping event that counts the results and shows the 1st three, then inserts the <br /> then iterates another three until the count is complete?