Table Help

[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

[ahundiak]

Your loop needs a bit of work. Something like this:

  echo '<table border="1">';
  $col = 0;
  while($array = mysql_fetch_array($res)) {

// First record in a group of 3 gets a tr
if ($col == 0) echo '<tr>';

// All records get this
echo '<td>',$array['alias'],'</td>';

// Third record gets a /tr
if ($col == 2) echo '</tr>';

// Reset every third record
$col++;
if ($col > 2) $col = 0;
  }
  // Final /tr if we need one
  if ($col != 0) echo '</tr>';

  echo '</table>';

[cschotch]

ok I get it ....I was tuck on how to write the code from the mysql commands....now that I see it Im hitting my head against the wall to try and bang some intelligence in there.....

But, when doing this how do you determine if there are any more variables and if not insert a &nbsp to make the table look right?

[cschotch]

duh!!

:o
Sorry figured that out when pressing the submit button.....