Insert a certain number of returned results into each table row...

[wintersHeart]

I was wondering if anyone knew how to make a certain number of MySQL results go into a new table row (<tr>).

For example, let's say I have 10 results (let's just, for sake of ease, say they're named 1-10, and I only want two results for every displayed table row). Does anyone know how to make every x number of results go into a new row?

example one (what I don't want).

<table>
<tr>
<td>1 2 3 4 5 6 7 8 9 10</td>
</tr>
</table>

example two (the basic idea of what I want).

<table>
<tr>
 <td>1 2</td>
</tr>
<tr>
 <td>3 4</td>
</tr>
<tr>
 <td>5 6</td>
</tr>
<tr>
<td>7 8</td>
</tr>
<tr>
 <td>9 10</td>
</tr>
</table>

Vague and probably hard to understand, but hopefully the examples will give you an idea.

[nemonoman]

$desiredCellsPerTableRow=2;
$count=1;
echo "<table><tr><td>"
while($row=mysql_fetch_array($resultOfSomeValidQuery)){
if($count<$desiredCellsPerTableRow){
echo "$row[0] ";
$count++;
}
else{
echo " $row[0]</td></tr><tr><td>";
$count=1;
}
}
echo "</tr></table>";
You'll have to mess with the code to handle uneven number of results.

[adi]

Another example here: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10270054