displaying information problem. please help

[__greg]

im having a problem displaying information im pulling from a mysql database. the problem isn't with the database, but with displaying the info.

im trying to make a table with 4 columns no matter what, but depending on how much information is present in the db, as many more rows as needed.

so if i had 4 pieces of info, it would be one row, but if i had 8 pieces of information, there would be 2 rows, each with 4 columns.. get it?

anyways, here's some of my code. if someone could help me try to figure this out, i'd appreciate it. thank you

if ($i <= 4)
	   		{			
	   		$i++;
			echo "<td valign=top width=185><a href=releases.php?id=".$row["id"]. "><img src=images/covers/100/".$row["cover100"]. " width=100 height=100 border=0><br><b>".$row["band"]. "</b><br><i>".$row["title"]. "</i></a></td>";	
			}			
	}
	echo "</tr></table>";

[bastien]

if statements only execute once...for statements will loop until completeness...change the if to a for loop

for($i=1;$i <= 4;$i++)
{

        echo "<td valign=top width=185><a href=releases.php?id=".$row["id"]. "><img src=images/covers/100/".$row["cover100"]. " width=100 height=100 border=0><br><b>".$row["band"]. "</b><br><i>".$row["title"]. "</i></a></td>";     
        }  //end for loop           

echo "</tr></table>";

[__greg]

hmm. that makes sense. but i tried using that in my code, and now it just display's the same information across in the same row, times 4.

im still having trouble with it displaying the different information in each cell, while still only having 4 cells per row.

i think the problem might be with my while statement, but im not 100% sure.

here's the whole code im working with right now, if someone could take a look at it i'd appreciate it. thanks.

while($row = mysql_fetch_array($result)) {
		if ($row['band_id'] == "0") {

	if ($i < 1)
   		{
   		$i++;
		echo "<b>Various Artists:</b>";
    	}
		}

	else {
		if ($i < 1)
   		{
		$i++;
		echo "<b>".$row["band"]. ":</b>";
    	}
    	} 
	echo "<table border=0 cellpadding=2 cellspacing=0><tr>";


	for($i=1;$i <= 4;$i++) 
	{ 
	echo "<td valign=top width=185><a href=releases.php?id=".$row["id"]. "><img src=images/covers/100/".$row["cover100"]. " width=100 height=100 border=0><br><b>".$row["band"]. "</b><br><i>".$row["title"]. "</i></a></td>"; 
	} //end for loop 
	}
	echo "</tr></table>";

[bastien]

close

echo "<b>Various Artists:</b>"; 
echo "<table border=0 cellpadding=2 cellspacing=0>

while($row = mysql_fetch_array($result)) { 
       for($i=1;$i <= 4;$i++)   

   if ($i==1){echo "<tr>"}; 


    echo "<td valign=top width=185><a href=releases.php?id=".$row["id"]. "><img src=images/covers/100/".$row["cover100"]. " width=100 height=100 border=0><br><b>".$row["band"]. "</b><br><i>".$row["title"]. "</i></a></td>";  

   if ($i==4){echo "</tr>"}; 

   } //end for loop 
} //end while loop
        echo "</table>";

[__greg]

alright, it seems like we're getting closer. i've played with it a lot and all i can get it to do is this:

(imagine this as my table):
what im looking for:
1 2 3 4
5 6 7 8
9...

what it is doing:
1 1 1 1

2 2 2 2
3 3 3 3

i know it's probably something stupid im just not picking up on. but seriously.. thanks for taking the time to help me with this.

[YappyDog]

I haven't actually tested it, but this should work..........

echo "<table border=0 cellpadding=2 cellspacing=0>
$i = 0;
while($row = mysql_fetch_array($result)) {
$i++;
if (fmod($i,4) == 1)
echo "<tr>";

echo "<td valign=top width=185><a href=releases.php?id=".$row["id"]. "><img src=images/covers/100/".$row["cover100"]. " width=100 height=100 border=0><br><b>".$row["band"]. "</b><br><i>".$row["title"]. "</i></a></td>";

if (fmod($i,4) == 0)
echo "</tr>";

} //end while loop

if (fmod($i,4) <> 0)
echo "</tr>";
echo "</table>";