Topic: PHP loop through database and limit number of entries

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 "<tr>";
        echo "<td>";
        echo "<img src=\"images/catalog/ottomans/thumbs/$chairImage\" width=\"157\" height=\"147\" />";
        echo "<br />";
        echo $chairName;
        echo "</td>";
        echo "</tr>";
       
       
    }

Re: PHP loop through database and limit number of entries

Have a look at the userlist.php table which is generated from the DB.

Sorry. Unactive due to personal life.