PHP loop through database and limit number of entries

programming
1

Hello,
Going to try to explain this as best I can. I have a bunch of stuff in a database and I need to display this info within a table. This isn’t a problem at all but, I need it to only display 3 td tags per line and then move on to the row.

so i need it to do :

code:

<table>
<tr>
<td>My First Row</td>
<td>My First Row 2</td>
<td>My First Row 3</td>
</tr>

<tr>
<td>My Second Row</td>
<td>My Second Row 2</td>
<td>My Second Row 3</td>
</tr>
</table>

and continue to do this through every entry in the database table.

so I have something like this that will display the info:

code:

for ($i = 1; $i <= $num; $i++){

    $chairArray = mysql_fetch_array($chairResult);
    $chairName = $chairArray['name'];
    $chairDescription = $chairArray['description'];
    $chairImage = $chairArray['image'];
    
    echo "&lt;tr&gt;";
    echo "&lt;td&gt;";
    echo "&lt;img src=\"images/catalog/ottomans/thumbs/$chairImage\" width=\"157\" height=\"147\" /&gt;";
    echo "&lt;br /&gt;";
    echo $chairName;
    echo "&lt;/td&gt;";
    echo "&lt;/tr&gt;";
    
    
}