display results within tables

[Anon]

how would i go about displaying results within complex tables, ie a new <td> is created for each record but every 3rd record </tr><tr> is also used ?

<table>
<tr>
<?
$sql = mysql_query(query string)
$list = mysql_num_rows($sql)
$row = mysql_result($sql)
$id = $row["db field"];
$item = $row["db field"];
while ($i < $list) {
print"<td>$id, $item</td>";
$i++;
}
?>
</tr>
</table>

tried the above with out much look, any pointers ??? i have tried counting but agian with no luck ie

$n=1
while ($i < $list) {
if ($n='3') {
print"<td>$id, $item</td></tr><tr>";
$i++;
$n+1;
}
else {
print"<td>$id, $item</td>";
$i++;
}
}
?>

sorry if some code wrong, not at home, sitting in an internet cafe @mo

thanks darren ramowski

[bouche]

what about trying something like this:

$i=0;
print '<table><tr>';
while ($row = mysql_fetch_array($query))
{
print "<td>$row[dbvar]</td>";
$i++
if ($i == 3)
{
print '</tr><tr>';
$i=0;
}
}
print '</tr></table>';

[nordberg]

You are close, but I think you need a FOR loop (check it out in the PHP manual). It's still early in the morning but try this (I am pretty sure it will work)..

<table>
<?php
//start a counter at 0
$i = 0
//$i will increment until its bigger than $list
while ($i <= $list) {
//create new rows until $i is bigger than $list
echo "<tr>\n";
//this loop will create three cells at a time then exit
for ($j = 0; $j <= 3; $j++😉 {
echo "<td>$id, $item</td>\n";
}
//increment $i by the number of cells just made (which will be 3 until $i approaches $list)
$i = $i + $j
//end the row after every three cells (or less if it the last pass
echo "</tr>\n";
}
?>
</table>