Line Wrapping w/ MySQL

[Anon]

I'm working on a simple shopping cart and the client wants the layout to have 3 product snapshots (a table tha includes price, thumbnail, short description, etc) per row. So if there are 8 products the layout should look like:

x x x
x x x
x x

x = 1 product

The problem is that im pulling all this info from a mysql database and im not sure how to format the script so that it will perform correctly no matter how many products are found.

i hope this makes sense...any help would be appreciated.

Champ

[reagent]

This should get you on the right path:

$iItemsPerLine = 3;
$iIndex = 0;

print "<table border=\"1\">";
while ($arrProduct = mysql_fetch_array($result))
{
if ($iIndex % $iItemsPerLine == 0)
{
if ($iIndex != 0)
{
print "</tr>\n";
}
print "<tr>\n";
}
print "<td>".$arrProduct['product_name']."</td>\n";
$iIndex++;
}

while ($iIndex % $iItemsPerLine != 0)
{
print "<td>&nbsp;</td>\n";
$iIndex++;
}
print "</tr>\n";
print "</table>\n";

just change $iItemsPerLine to whatever value you need, and it will work as expected.

hth
p.