Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › How to add a break point in MySQLi results

How to add a break point in MySQLi results

Thread began 10/01/2014 10:13 am by Steve | Last modified 10/01/2014 11:08 am by Jason Byrnes | 1709 views | 5 replies |

10/01/2014 10:13 am | #1 Steve

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?

10/01/2014 10:17 am | #2 Jason ByrnesWebAssist

add a count tothe repeat and add a <br/ > at 3

<?php $count = 1; ?>
<?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
    $count++;
    if($count == 4) {
        echo("<br />");
        $Count = 1;
    }
?>
 <?php
  $Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
?>

10/01/2014 10:31 am | #3 Steve

That works great, but only puts a single break after three and then does not repeat for the second set :-(

http://rivieralaser.com/photos15.php?id=36

<?php $count = 1; ?>
<?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> 
  
  
  <?php
    $count++;
    if($count == 4) {
        echo("End <br />");
        $Count = 1;
    }
?>


  <?php
  $Recordset1->moveNext();
}
$Recordset1->moveFirst(); //return RS to first record
?>

10/01/2014 10:34 am | #4 Jason ByrnesWebAssist

sorry:
$Count = 1;

should be:
$count = 1;

10/01/2014 10:40 am | #5 Steve

Oh I see now... The $count increases with each iteration ($count++) and then there is the conditional statement that inserts the Break.
Next the $count resets so as to be able to loop again.

Awesome! Thanks Jason.

We could also use zero as the initial starting point:

<?php $count = 0; ?>
<?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> 
  
  
  <?php
    $count++;
    if($count == 3) {
        echo("End <br />");
        $count = 0;
    }
?>

10/01/2014 11:08 am | #6 Jason ByrnesWebAssist

yes, you could use 0 as the starting point if you like

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.