PHP loop through database and limit number of entries

[gilbertsavier]

Hi,
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>";


}

_________________
Thanks & regards
Lokananth

[gregor171]

$result = mysql_query("SELECT name, description, image FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    ....
}

I like this simple sample from:
http://us.php.net/mysql_fetch_array

[bmcoll3278]

here is the code I use. notice the LIMIT and OFFSET

so you change the limit to 3 and then do a second query and set the offset to 6 then a 3rd query with the offset set to 9 ect,,

to see an ex. look at my site the news feed menu at the top is built this way. link in my sig. here is the code

<?php
$result = mysql_query("SELECT * FROM dyn_menu where cat='news'LIMIT 8");

while($row = mysql_fetch_array($result))
{

$linky[0] = "$row[links]";
$linky[1] = "$row[link_url]";



$thelinks= "<b><a href='$linky[1]'>$linky[0]</a>,</b> ";

echo"$thelinks";
}
echo"<BR>";
$result = mysql_query("SELECT * FROM dyn_menu where cat='news'LIMIT 8 OFFSET 8");

while($row = mysql_fetch_array($result))
{

$linky[0] = "$row[links]";
$linky[1] = "$row[link_url]";



$thelinks= "<b><a href='$linky[1]'>$linky[0]</a>,</b> ";

echo"$thelinks";
}
echo"<BR>";
?>