Columns and remainders

[sylunt1]

Greetings...

I have some code that I am trying to apply to a different area of my site... the issue is that the data used for this page is not an even number and gets stuck in a loop (there were say 40 rows in the one that worked and only 39 here). If I enter a bogus row to make the number of rows even it works - except this doens't really help.

So what I need is a way to handle remainders...

<?php

$result = mysql_query ("SELECT beerstyle_id, beerstyle_name FROM bm_beerstyle ORDER BY beerstyle_name") or die(mysql_error());

$total = mysql_num_rows($result);
$numCols = 2;
$numRows = floor($total / $numCols);


while($row = mysql_fetch_array($result))
{
    $beerstyle_id = $row['beerstyle_id'];  
    $beerstyle_name = $row['beerstyle_name'];


echo ('<table width="80%">');

for ($y = 0; $y < $numRows; $y++) {

echo ('<tr>');

for ($x = 0; $x < 2; $x++) {

  $offset = $y + ($x * $numRows);
    if ($offset < $total) {

        mysql_data_seek($result, $offset);
        $row2 = mysql_fetch_array($result);

  echo ('<td width="50%"><a href="beerstyle.php?id='.$row2['beerstyle_id'].'">'.$row2['beerstyle_name'].'</a></td>');
    }

}

echo ('</tr>');
}

echo ('</table>');
    }                                                      

?> 

[barand]

This is my method for multiple columns

define('COLS', 2);

echo "<TABLE border='1'>";
$n = 0;
$res = mysql_query("select afield from atable ");
while (list($afield)=mysql_fetch_row($res)) {
       if ($n % COLS == 0) echo '<tr>';
       echo "<td>$afield</td>";
       $n++;
       if ($n % COLS == 0) echo '</tr>';
}
if ($n % COLS != 0) {
    # next line handles remainder
    while ($n++ % COLS != 0) echo "<td>&nbsp;</td>";
    echo "<tr>";
}
echo "</table>";

hth

[sylunt1]

OK this may seem like a dumb question... but how do I incorporate that into my code?

Thanks...

Chris

[barand]

define('COLS',2);

echo "<TABLE border='1'>";
$n = 0;
$res = mysql_query("SELECT beerstyle_id, beerstyle_name FROM bm_beerstyle ORDER BY beerstyle_name ");
while (list($id,$name)=mysql_fetch_row($res)) {
       if ($n % COLS == 0) echo '<tr>';
       echo "<td><a href=\"beerstyle.php?id=$id\">$name</a></td>";
       if (++$n % COLS == 0) echo '</tr>';
}
if ($n % COLS != 0) {
    while ($n++ % COLS != 0) echo "<td>&nbsp;</td>";
    echo "<tr>";
}
echo "</table>";