[RESOLVED] putting checkboxes into rows

[joe69]

Hi
I have decided to create an array of my checkboxes. getting them from my DB.

what I would like to do is to put them into rows. there are 9 checkboxes.

Here is my code. it lists them just in one row.

echo "<TR>";
$sql = "SELECT * FROM interests ORDER BY id ASC";
$result = @($sql);
WHILE ($row = @mysql_fetch_array($result))
{
$id = $row['id'];
$value =htmlspecialchars($row['value']);
echo "<TD colspan=3><input type=Checkbox value=$id>$value</TD>";
}
echo "</TR>";
how do I make 3 rows of 3? Thanks in advance Joe

[bpat1434]

Search the board for a vertical/horizontal looper. You'd be surprised to find: my Vertical & Horizontal Looper Function.

[joe69]

This one isnt resolved yet. I am too new to PHP and coding for this to make any sense as yet.
I was hoping it would be more simple. I may have to jsut hard code them into the page until I can learn more about this. your example shows making rows of numbers. I wanted to create 3 rows of checkboxes and pull their tags out of the database. any other ideas?

Joe

[bpat1434]

If you want a table row, you could always just use the modulus operator to see if $i (which you have to set up) is divisible by 3. If so, start a new row, otherwise, continue. Something like:

$i=0;
while($row = mysql_fetch_array($result))
{
    // If $i / 3 has no remainder (i.e. $i == 3, 6, 9, 12, 15, etc.)
    if($i%3==0)
        echo '<tr>';

$value =htmlspecialchars($row['value']);
echo "<TD colspan=3><input type=Checkbox value=$id>$value</TD>";
}

echo '</tr>';

Hope that helps...

[joe69]

Modulus worked great THANKS!!!!

Joe