如何通过2组回应结果？

Question

How do I modify an SQL result set so that the result is (A) and not (B). I need to somehow break the loop for every 2 results so that those two results get wrapped around a row class. Please see below:

(A) What I like to happen:

<div class="row">
  <div class="large-6 columns"></div>
  <div class="large-6 columns"></div>
</div>

<div class="row">
  <div class="large-6 columns"></div>
  <div class="large-6 columns"></div>
</div>

(B) What happens:

<div class="row">
   <div class="large-6 columns"></div>
   <div class="large-6 columns"></div>   
   <div class="large-6 columns"></div>
   <div class="large-6 columns"></div>
</div>

CODE:

<div class="row"> 

<?php $query = "SELECT * FROM recipe";

$result = mysql_query($query);

while($row = mysql_fetch_array($result)) {
?>         

  <div class="large-6 columns">          

     <h4><?php echo $row['recipe_title'] ?></h4>

     <p><?php echo $row['recipe_description'] ?></p> 

  </div> 

<?php } ?>

</div>  

Answer 1

You could try to add a counter variable, which is increased everytime the loop is called. Use the modulus operator then to close the current row and open a new one after the loop was called twice:

<div class="row"> 

<?php $query = "SELECT * FROM recipe";

$result = mysql_query($query);
$i = 1;
while($row = mysql_fetch_array($result)) {
?>         

  <div class="large-6 columns">          

     <h4><?php echo $row['recipe_title'] ?></h4>

     <p><?php echo $row['recipe_description'] ?></p> 

  </div> 

<?php 
    if($i % 2 === 0) {
        echo '</div><div class="row">';
    }
    $i++;
} 

?>

</div>