Help with Looping a table row!!!

cosmo7

OK here goes... I have a page... which can be viewed
OVER HERE
WHAT I WANT is a ROW for EACH 3 ITEMS and NOT what's on that page!!!
That page's script is:

<html>
<body>
<script language="JavaScript">
<!--

function SymError()
{
return true;
}

window.onerror = SymError;

//-->
</script>

// --></script>
<?php
include("dbinfo.inc.php");

$db = mysql_connect("$database", "$username", "$password");

mysql_select_db("jewel_items",$db);

$result = mysql_query("SELECT * FROM items WHERE subcat='$subcat'",$db);
$num = mysql_numrows($result);
?>

<table border="1" cellspacing="0" cellpadding="2" width="600px">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Column1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Column2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Column3</font></th>
</tr>
<?
$i=0;

<? while ($i < $num) {
$picture=mysql_result($result,$i,"picture");
?>
<td><dl><dd><font face="Arial, Helvetica, sans-serif"><a
href="large.php?picture=<? echo "$picture"; ?>"
onclick="NewWindow(this.href,'name','500','275','no');return false;"><img
src="http://www.jewelsofisrael.co.il/giftshop/gold/earrings/thumbnails/<? echo "$picture"; ?>+.jpg" border="1"</font>
</dd></dl><br></td>

++$i;
}

?>
</table>
</body>
</html>

Can somebody PLEASE help me???

diego25

You are close 🙂 You just need to output more <tr> tags so that you get the next row, instead of everything in one row...

Something like this:

<tr>
<? while ($i < $num) {
$picture=mysql_result($result,$i,"picture");
?>
<td><dl><dd><font face="Arial, Helvetica, sans-serif"><a
href="large.php?picture=<? echo "$picture"; ?>"
onclick="NewWindow(this.href,'name','500','275','no');return false;"><img
src="http://www.jewelsofisrael.co.il/giftshop/gold/earrings/thumbnails/<? echo "$picture"; ?>+.jpg" border="1"</font>
</dd></dl><br></td>

<?
++$i;
if ($i % 3 == 0) {
print "</tr><tr>";
}

}
?>
</tr>