[RESOLVED] for loop or while loop?

[phpforme]

hi, im pretty new to php. i have a product table. im reading the products from the table and display it on the page. the way i want to display is to have four items on each row in a table.

how do i code so that it will read four items and then jump to a new row?

i have this and it's basically putting all the products in a <td>.

echo '<table border="0" cellpadding="0" cellspacing="0"><tr><td>';
foreach ($records as $record)
{
echo '<a href="jewelry_item.php?jewelryID=' . $record['jewelryID'] . '">';
echo '<img src="" alt="" title="" class="first" border="0"/></a>';
echo '<a class="prod-name" href="jewelry_item.php?jewelry_id=' . $record['jewelryID'] . '">';
echo $record['jewelryName'] . "</a>";
echo '<div class="prod-price">Price: <span>';
echo $record['jewelryPrice'] . "</span></div></div>";
}
echo '</td></tr></table>'

i know i should use $counter and while or for loop. I just dont know how.. Please help!

[bpat1434]

You could use the modulus operator here. Set the counter to 1, then increment after each row.

$counter = 1;

echo '<table border="0" cellpadding="0" cellspacing="0"><tr><td>';
foreach ($records as $record)
{
    if($counter % 4 == 0)
        echo '</tr><tr>';

echo '<a href="jewelry_item.php?jewelryID=' . $record['jewelryID'] . '">';
echo '<img src="" alt="" title="" class="first" border="0"/></a>';
echo '<a class="prod-name" href="jewelry_item.php?jewelry_id=' . $record['jewelryID'] . '">';
echo $record['jewelryName'] . "</a>";
echo '<div class="prod-price">Price: <span>';
echo $record['jewelryPrice'] . "</span></div></div>";

$counter++;
}
echo '</td></tr></table>';

You can google for modulus; however, the basic idea is that if you take the left, divide it by the right (so in our example X divided by 4), and return the remainder. We check if the remainder is 0 (i.e. X = 4, 8, 12, 16, 20, 24, 28, etc.). So 1/4 will have a remainder of 0.25, 2/4 will be 0.50, 3/4 will be 0.75 and 4 will be 0. So by checking if the remainder is 0, then you know it's been X rows.

Hope that helps.

[phpforme]

Thank you so much! it worked. Had to change to $counter to 0 though. $counter=1 cuts every 3 items instead of 4. But your concept totally works. Thanks again!

[bpat1434]

Glad to help. Please don't forget to mark this as resolved.