How to add <div> after 3 records have been output when using while (mysql)

[madhead29]

I am trying to make it so after 3 records are echoed out a div is put around the 3 boxes as like a container. The reason i am doing this is that my current code use all seperate boxes with the same class but if the text goes down abit more than the other 3 is pushes the box along that is ment to go under it.

My Current code is:

<?php $inflatable_query="SELECT id,title,image_url,thumb_url FROM products WHERE area=1 ORDER BY id;";
$inflatable_result=@mysql_query($inflatable_query);
while($inflatable_data=@mysql_fetch_array($inflatable_result)){

?>


<?php echo "<div class=\"inflatable-box\"> \n"; ?>
<?php echo "<div class=\"inflatable-box-image\"><a href=\"product-".$inflatable_data['id'].".php \" target=\"_blank\"><img src=\"".$inflatable_data['thumb_url']."\" width=\"200px\" height=\"200px\" border=\"0\" /></a></div>"; ?>

<?php echo "<div class=\"inflatable-box-text\">".$inflatable_data['title']."</div>
</div>"; ?>
<?php } ?> 

Does anyone know the best way to do this? Thanks in advance.

[dagon]

basiclly:

$i=0;
while(){
$i++;

if($i==3){
}

}

[madhead29]

Hi Thanks for the reply but i am pretty new to PHP and mysql and Im not sure where ur code would go: I think i understand this bit:

$inflatable_query="SELECT id,title,image_url,thumb_url FROM products WHERE area=2 ORDER BY id;";
$inflatable_result=@mysql_query($inflatable_query);
$i=0;
while($inflatable_data=@mysql_fetch_array($inflatable_result)){
$i++

Is that correct for that bit?

but im not sure where i would put:

if($i==3){
}

}

With this:

<?php echo "<div class=\"inflatable-box"\"> \n"; ?>
<?php echo "<div class=\"inflatable-box-image\"><a href=\"product-".$inflatable_data['id'].".php\" target=\"_blank\"><img src=\"".$inflatable_data['thumb_url']."\" width=\"200px\" height=\"200px\" border=\"0\" /></a></div>"; ?>

<?php echo "<div class=\"inflatable-box-text\">".$inflatable_data['title']."</div>
</div>";
?>

Please help?

[dagon]

$i=0;
while(){
$i++;
what ever you want in the while loop
if($i==3){
what ever you want to happen on the third iteration of the while loop
}

}

[madhead29]

Sorry that dont make much sense to me. Thanks anyway.

[azizsaleh]

Do you mean you want every three records to be inserted into a table row of their own?

[Haddman]

What dagon is talking about is that you count up to three with the while loop and when $i hits three the if statement gets executed.
This is what i would do:

// There's no need to use <?php, you can use <?, easier, takes less space
<?php $inflatable_query="SELECT id,title,image_url,thumb_url FROM products WHERE area=1 ORDER BY id;";

// Do you know what @ does? If not it tells the browser that if there's an error with the query he doesn't show it wich can be a pain if you forget about it and there is an error.
$inflatable_result=@mysql_query($inflatable_query);
while($inflatable_data=@mysql_fetch_array($inflatable_result)){

?>

// Why close php and reopen it to write html code?
<?php echo "<div class=\"inflatable-box\"> \n"; ?>
<?php echo "<div class=\"inflatable-box-image\"><a href=\"product-".$inflatable_data['id'].".php \" target=\"_blank\"><img src=\"".$inflatable_data['thumb_url']."\" width=\"200px\" height=\"200px\" border=\"0\" /></a></div>"; ?>

<?php echo "<div class=\"inflatable-box-text\">".$inflatable_data['title']."</div>
</div>"; ?>
<?php } ?> 

Becomes:

<?
$inflatable_query="SELECT id,title,image_url,thumb_url FROM products WHERE area=1 ORDER BY id;";

$i=0;
$inflatable_result=mysql_query($inflatable_query) or die("An error has occured: ".mysql_error());
while($inflatable_data=mysql_fetch_array($inflatable_result)){
$i++;
if($i==3){
  $open_div="<div>";
  $close_div="</div>";
  //If you wanna run this multiple times the reset $i
  $i=0;
}
echo $open_div;
?>
<div class="inflatable-box">
<div class="inflatable-box-image">
  <a href="product-<?=$inflatable_data['id'];?>.php" target="_blank"><img src="<?=$inflatable_data['thumb_url'];?>" width="200px" height="200px" border="0" /></a>
</div>
<div class="inflatable-box-text"><?=$inflatable_data['title'];?></div>
</div>
<?
}
echo $close_div;
?>

<?= is the same as <? echo or <?php echo

[johanafm]

// Personally I prefer
$i = 1;	// No need to reset $i
$openDiv = '<div>'	// Only assign once
$closeDiv = '</div>'	// Only assign once
while(...) {
// as before

// You missed the crucial part (unless I'm just blind)
	if ($i%3 == 0) {
		echo $closeDiv . $openDiv;
	}
}

[Haddman]

Can't delete...