[SOLVED] Do while statement to give rows

[Voodoo Jai]

I have a do while statement that I want to display 4 adverts in a 2x2 grid

How do I display the first 2 advert on the first then then the next 2 in another row.

 

I have this code so far but are stuck now/

<?php
do
{
$Advert = $row_Adverts['Link'];
echo "<img src=\"$Advert\">"." ";
}
while ($row_Adverts = mysql_fetch_assoc($Adverts));
?>

 

Many thanks

VoodooJai

[kenrbnsn]

You need a counter to see how many you've already displayed:

<?php
$i = 0;
while ($row_Adverts = mysql_fetch_assoc($Adverts)) {
      echo '<img src="' . $row_Adverts['Link'] .'"> ';
      $i++;
      if ($i == 2) echo '<br>';
}
?>

 

This is one way of doing it (untested).

 

Ken

[Voodoo Jai]

You need a counter to see how many you've already displayed:

<?php
$i = 0;
while ($row_Adverts = mysql_fetch_assoc($Adverts)) {
      echo '<img src="' . $row_Adverts['Link'] .'"> ';
      $i++;
      if ($i == 2) echo '<br>';
}
?>

 

This is one way of doing it (untested).

 

Ken

 

I think this is what works, does it look right!!!!!

 

<?php
$rows = 0; 
do
{ 
  $Advert = $row_Adverts['Link'];
  echo "<img src=\"$Advert\">"." ";
  $rowS++;
  if ($rowS == 2) echo "<br/>";
  }
while ($row_Adverts = mysql_fetch_assoc($Adverts));
?>