[RESOLVED] Multiple Columns For Statement

[snb828]

I'm trying to get a table to automatically populate columns based on information in a mysql database. What I need is the first sport to be in column 1, the second in 2, the 3rd in 3, then 4th back in 1 etc... What I get is sport 1 as column 1,2,3 and sport 2 in column 1,2,3 etc... Where has my code gone wrong?

<?php
$q = "SELECT * FROM `Sports` ORDER BY `SportNumber` ASC";
   $result = $database->query($q);
   $num_rows = mysql_numrows($result);
for($i=0; $i<$num_rows; $i++){
$name  = mysql_result($result,$i,"SportTitle");
$a_array = 'Athlete' . mysql_result($result,$i,"SportDatabase");
?>
              <tr>
                <td width="33%"><label><input type="checkbox" name="$name" <?php if($form->value($name) != "Y" || $athlete[$a_array] != "Y"){ echo" checked"; } ?> /><?php echo($name); ?></label></td>
                <td width="33%"><label><input type="checkbox" name="$name" <?php if($form->value($name) != "Y" || $athlete[$a_array] != "Y"){ echo" checked"; } ?> /><?php echo($name); ?></label></td>
                <td width="33%"><label><input type="checkbox" name="$name" <?php if($form->value($name) != "Y" || $athlete[$a_array] != "Y"){ echo" checked"; } ?> /><?php echo($name); ?></label></td>
              </tr>
<? } ?>

Thanks in advance,
~Scott

[devphp12]

hi
is it fix that all sport has same number of column?
spot1 - 1 2 3
spot2 - 4 5 6
etc?

[snb828]

If I understand you correctly, that's exactly what I don't want.

I want:
1 - 2 - 3
4 - 5 - 6
7 - 8 - 9
etc

OR
1 - 4 - 7
2 - 5 - 8
3 - 6 - 9
etc

I get:
1 - 1 - 1
2 - 2 - 2
3 - 3 - 3
4 - 4 - 4
5 - 5 - 5
etc

Hopefully this makes more sense...
Ive got a friend coming ovr to help me cuz he has an idea, but please continue to post ideas in case he's wrong.

I'll post it if it works!

[laserlight]

Think about $i % 3, and how you can use its result to determine when to begin and end rows.

[snb828]

Thanks laserlight,

Maybe i'm just a super-n00b but I have no idea what that means.... I assume it has something to do with division and remainders but idk how it's used... any help or guidance is appreciated!

~Scott

[laserlight]

Consider something along these lines:

<?php
$query = "SELECT * FROM `Sports` ORDER BY `SportNumber` ASC";
$result = $database->query($query);
$num_rows = mysql_num_rows($result);
for ($i = 0; $i < $num_rows; ++$i) {
    if ($i % 3 == 0) {
        // Begin new table row.
        echo '<tr>';
    }

$name  = mysql_result($result, $i, "SportTitle");
echo '<td>' . htmlspecialchars($name) . '</td>';

if ($i % 3 == 2) {
    // End current row.
    echo '</tr>';
}
}

// Insert blank table cells if necessary.
for (; $i % 3 != 0; ++$i) {
    echo '<td>&nbsp;</td>';

if ($i % 3 == 2) {
    // End current row.
    echo '</tr>';
}
}
?>

Incidentally, note that mysql_numrows() is deprecated in favour of mysql_num_rows(). Then again, you should use the MySQLi extension or the PDO extension instead.

[snb828]

Thanks!!! Brownie points for you!!!! 😃