looped query results and custom table

[Anon]

I am trying to generate a table based on a results from a query. My goal is to have a table 4 columns by n rows with the results from the query occupying each cell respectively. My code below prints each result in a long row setting each new column next to the last. I want to insert <tr> </tr> tags after every 4th result that is pulled from the query. Any suggestions/advice would be appreciated.

$c1 = new DB_get;
$c1->dbResults("query here...");
print("<table border=0 cellpadding=5 cellspacing=0 width=100%>");
print("<tr>");
while ($row = mysql_fetch_array($c1->sqlQuery)){
print ("<td>" . $row["result_field"] . "</td>");
}
print("</tr>");
print("</table>");

[hessian]

Two way I can think of doing this... But another thing to keep in mind, you may want to have it spit out a colspan or more td's if you dont have enough coumns for the last set.
$counter = 0;
while ($row = mysql_fetch_array($c1->sqlQuery)){
$counter++;
if($counter == 1)
{
echo "<tr>"
}
echo "<td>" . $row["result_field"] . "</td>";

if($counter == 4)
{
echo"</tr>";
$counter = 0;
}
} // end of while
if($counter != 0)
{
$tmpnum = 4 - $counter;
echo "<td colspan=\"$tmpnum\"></td>";
}
I think that all works. Hope that helps.

[Anon]

you rock, that worked... thanks for you time