Table problem

cschotch

I have a table that is supposed to look like this

<table>
  <tr>
    <td></td>
    <td></td>
    <td></td>
  </tr>
//repeat ad nauseum for number of records in 3's
</table>

But it still only displays the records down 1 row....
I have 31 names I need them to go across the screen (3 at a time) then go the next 1 down etc.....
here is the php

<?php
mysql_connect('localhost', 'username', 'password');
mysql_select_db('database');
$res = mysql_query("SELECT * FROM roster ORDER BY Alias");
$rest = mysql_fetch_row($res);
$data = mysql_num_rows($res);
echo $data;
$max_data = 3;
print '<table border=\"1\">';

while($array = mysql_fetch_array($res)){  

  for ( $y=1; $y<=1; $y+=$data )
    {
    echo '<tr>';
      for ( $x=1; $x<=1; $x+=$max_data )
        {
        echo '<td>';
	echo $array[Alias];
	echo '</td>';
        }
    echo '</tr>';
   }
}
  echo '</table>';
?>

thanks for any and all help

diego25

In your code, you're fetching the row ONCE, and printing it out 3 times! So there should be another fetching inside the for loop, too, right? Should make sense...

But your method expects the number of rows to be a multiple of 3. But what if it's not? Here's something for you to consider (i.e. it won't work as it is)

$max = 3;
$current = 1;
while ($row = mysql_fetch_array($result)) {
print $row['Alias'] . ' ';
if ($current % $max == 0) {
print "<br />\n";
}
$current++;
}

The % operator is the modulus operator, which returns the remained of a division. e.g.
5 % 3 == 2
10 % 3 == 1
6 % 3 == 0

Diego