[RESOLVED] displaying the results of an array in sets

[notaloser]

im trying to make an image gallery, and i query the location of the pictures. what i want is the results as an array to be displayed in sets of 4 in each <tr> of a table. heres what i have. i've never displayed arrays this way so im confused.

$kidsquery = mysql_query("SELECT * FROM gallery WHERE gallid = 1 ");
$kidsrows = mysql_num_rows($kidsquery);


if(empty($kidsrows)) {
	echo "No pics";
}else{

echo "<table width='100%' cellpadding='3s' cellspacing='7' align='center'>";


	while($kidsarray = mysql_fetch_array($kidsquery)) {

echo "<tr><td width='25%'><div align='center'><img src='http://n3graphics.com/notaloser/caha/uploads/".$kidsarray[filename]."' alt='".$kidsarray[caption]."' length='100' width='100'></td>";
echo "<td width='25%'><div align='center'><img src='http://n3graphics.com/notaloser/caha/uploads/".$kidsarray[filename]."' alt='".$kidsarray[caption]."' length='100' width='100'></td>";
echo "<td width='25%'><div align='center'><img src='http://n3graphics.com/notaloser/caha/uploads/".$kidsarray[filename]."' alt='".$kidsarray[caption]."' length='100' width='100'></td>";
echo "<td width='25%'><div align='center'><img src='http://n3graphics.com/notaloser/caha/uploads/".$kidsarray[filename]."' alt='".$kidsarray[caption]."' length='100' width='100'></td></tr>";


	}
}

what i have is just a filler for now

[notaloser]

up

[barand]

try something like this

define ("NUMCOLS",4);

$res = mysql_query("SELECT imagename FROM mytable");

$count = 0;
echo "<TABLE border=1>";
while (list($img) = mysql_fetch_row($res)) {

if ($count % NUMCOLS == 0) echo "<TR>\n";  # new row

echo "<TD><img src='$img'></TD>\n";
$count++;

if ($count % NUMCOLS == 0) echo "</TR>\n";  # end row
}
if ($count % NUMCOLS != 0) {
   # end row if not already ended
   while ($count++ % NUMCOLS) echo "<td>&nbsp;</td>";
   echo "</TR>\n";
}
echo "</TABLE>";

[notaloser]

thanks for the response, sorry ive been a little sick and couldnt check back.

i went ahead and tried a setup like this, and it listed it only 1 to a row, not 4.

plus, this way wont work because i need more than one column from the table in my database.

anyone else? ive been trying something and ill post it in a little

[notaloser]

nevermind all worked out, thanks