[RESOLVED] table results columns rows

LordRogaine

I thought I had this resolved but I was wrong. I am having trouble implementing my coding to work with the desired results. I am calling up a total of ten thumbnail images to appear in a table. I would like these to be in two rows of five. The code below will produce the thumnail images in a table, but all ten are in one row. How can I break this up so that after five images it will start a new row? Here is the code I am using now to show the thumbnails.

$query = "SELECT * FROM images limit 0,10";

// execute the query
$result = mysql_query($query);

// get the number of results
$num_rows = mysql_num_rows($result);

// start the results table
?>

<?php

for ($i=0; $i<$num_rows; $i++){
// fetch row
$img_info = mysql_fetch_array($result);
// start table row
echo '<td valign=\"bottom\">';

// generate the image tag
echo img_tag($img_info["img_file"], array("x"=>"100", "y"=>"100"));


echo "</a></td>";

}
?>[/COLOR]
</tr></table>

WDPEjoe

$numInRow = 5; // you can change this to whatever you want
for ($i=0; $i<$num_rows; $i++){
if ($i % $numInRow == 0) { print ("<tr>"); }
// fetch row
$img_info = mysql_fetch_array($result);
// start table row
echo '<td valign=\"bottom\">';

// generate the image tag
echo img_tag($img_info["img_file"], array("x"=>"100", "y"=>"100"));


echo "</a></td>";

if ($i % $numInRow == $numInRow-1) { print ("</tr>"); }

}

LordRogaine

It works perfectly! Thank you very much!!

WDPEjoe

I forgot...

This will generate invalid HTML (there won't be a valid number of cells in the last column) when $iFinal is not a multiple of $numInRow.

So, here is the code to tack on the end to make sure the table is properly made

//after the for loop
if ($i % $numInRow != $numInRow-1) { print ("<td colspan=\"" . ($numInRow-$i%$numInRow-1) . "\">&nbsp</td></tr>"); }
print ("</table>");