Outputing info in table from mysql query

mybikeisace

I have the this code that will output the data from my database into a table:

$query= "SELECT * FROM picinfo WHERE catogry='$catogry'";

$result=mysql_query($query);

$num_results = mysql_numrows($result);

for ($i=0; $i < $num_results; $i++)
{
$row= mysql_fetch_array($result);

?>

<tr>
<td>Picture Thumnail goes here
</tr>

<tr>
<td>Last Modfied: <?php echo $row['date']; ?>
</tr>

</table>

<?

}
?>

This works fine, with record in a seperate table, aligned under each other. What I want to do is have 3 tables per line, then start a new line. I tried many way, eg nesting the loop inside another one, or testing the moduls of $i to see if its dividble by 3, but none worked.

rinjani

You want three tables per line or three table cells per line?

Either way you need to do it all within the PHP section of your code, rather than dropping into HTML alone.

for ($i=0; $i < $num_results; $i++)
{
($row= mysql_fetch_array($result)) {

echo "
<tr><td>
<table>
<tr><td>
$row['0']
</td><td>
$row['1']
</td><td>
$row['2']
</td>
</tr>
</table>
</td>
";

//then check the mod

if (($i % 3) == 0) {

echo "</tr>";

}

$i++
}

}

Then go through until it's done and echo out the final <td> - <table> code to close it.

At least it's close to right as written, you may need to play a little to get it exactly as you want.

HTH

mybikeisace

Thanks for you help, got it sorted now. It was just the modlus thing I couldnt figure out how it worked probably.