[RESOLVED] Arrange dynamically loaded items?

[ElectricRain]

Ok so what im doing is grabbing products from a database, n i have set it to display 15 items per page, now what im tryin to achieve is displaying them in rows of 3. So far I have:

while($each_item = mysql_fetch_array($get_items_query)) { 
     echo ("<table width='120' height='120' style='border: 1px solid #999999;'><tr><td align='center'>
     <a href='index.php?p=productdetails&prodid=".$each_item['id']."'>
     <img src=".$each_item['imagepath']." border='1' alt='".$each_item['productname']."' border='0'>
     <br>".$each_item['productname']."</a>
     </td></tr></table> &nbsp;");
}

which displays the items one after another, vertically down the page. I suppose if I removed the tables theyd display beside one another, but then id be worried the info wouldnt display directly below the image if ya see what I mean. what im looking for is a php way of saying "for the first 3 items" { display in this top table row } and then "for the next 3 items" {display in a second table row } or something like that? can it be done?

[Houdini]

Do you think this would do?

$count=1; 
while($each_item = mysql_fetch_array($get_items_query)) { 
  if ($count>=3){ 
     //Do whatever you want in this space put a horizontal rule or place an advertisement or something 
     $count=1; 
     } 
  else{ 
     echo ("<table width='120' height='120' style='border: 1px solid #999999;'><tr><td align='center'> 
     <a href='index.php?p=productdetails&prodid=".$each_item['id']."'> 
     <img src=".$each_item['imagepath']." border='1' alt='".$each_item['productname']."' border='0'> 
     <br>".$each_item['productname']."</a> 
     </td></tr></table> &nbsp;"); 
     $count++; 
    } 
} 

[ElectricRain]

Ugh I thought ya had it there.. almost.. theres just one lil problem- the every 4th item is being missed completely. so now I have this:

$count = 1; 
echo ("<table width='420'><tr>");
while($each_item = mysql_fetch_array($get_items_query)) { 
     if ($count >= 4) { echo ("</tr><td colspan='3'><br></td></tr><tr>");
     $count = 1; } 
     else{ 
         echo ("<td>$count<table width='120' height='120' style='border: 1px solid 
         #999999;'><tr><td align='center'> 
         <a href='index.php?p=productdetails&prodid=".$each_item['id']."'> 
         <img src=".$each_item['imagepath']." border='1' alt='".$each_item       

          ['productname']."' border='0'> 
         <br>".$each_item['productname']."</a> 
         </td></tr></table></td>"); 
          $count++; 
     } 
} 
echo ("</tr></table>");

n it shows item 1, 2, 3, misses 4, shows 5, 6, 7, misses 8 n well.. you get the idea.

[Weedpacket]

Here's something I wrote a while back after seeing this question asked often in these forums.
http://www.phpbuilder.com/board/showthread.php?s=&postid=10593202#post10593202

[ElectricRain]

I tried but I cant get my head around that. too much math. 😐 I think Im almost there? Isnt it just something small Im missing? I understand that it doesnt work cuz on item number 4 Im saying change the count back to 1, so 4 gets skipped... I just need to find a way of not doing that...

[ElectricRain]

Nevermind cracked it. I was saying "if count is a multiple of 3 start a new row", instead of "if count is a multiple of 3 start a new row AND display the item" basically Im an idiot 🙂 Thanks neway. 😉