Adding columns to loop

[1042]

Hello all,

how can i make this results show in columns of 4, so for each category display the users;

$sqlCat   = MySQL_Query("SELECT dep_name FROM staff_departments ORDER BY dep_name");

while($cat = mysql_fetch_array($sqlCat)) {
  echo '<table border="0">'.
       '<tr>'.
       '<td><b>'.$cat['dep_name'].'</b></td>'.
       '</tr>';
  $sqlLinks = MySQL_Query("SELECT * FROM users WHERE staff_office = '$cat[dep_name]' ");

  while($link = MySQL_Fetch_Array($sqlLinks)) {
    $link_name[] = $allLinks['staff_name'];
    echo '<tr>'.
         '<td>'.$link['staff_name'].'</td>'.
         '</tr>';
  }
  echo '</table>';
}

thanks for any help.

[bradgrafelman]

Have you already tried searching the board with keywords like "display column" or "mysql column" ? This topic has been covered countless times.

In fact, in a recent thread, I tried my hand at coding something similar.