displaying sql table data using php

[php1306]

I'm trying to make a page that will show all the users in a table and add a little "add user to friends list" button beside each one. So far i have the code displaying the users but it's displaying all the information on one line. Any ideas on how to fix the named problem and how to achieve my goal?

Thanks

The code i already have for the "friends" page is:

<?php

$q = mysql_query("SELECT username, user_id FROM user") or die(mysql_error());
$x=0;

echo"
<table>
<tr>
       <th> user id</th>
       <th> username</th>";

while($row = mysql_fetch_array($q)){
  extract($row);
  if ($x==0){
    echo "</tr><tr>";
  }
  $x++;
  if ($x == 3){
    $x = 0;
  }
   echo "<td>$user_id</td>";
  echo "<td>$username</td>";

}
echo"</tr></table>";
?>

I've also attached what it currently looks like in a webpage.

[Derokorian]

First, Welcome to PHPBuilder! Please use the [NOPARSE]

[/NOPARSE] tags when posting PHP code to make it easier to read.

As for your question.. the answer is easy, the code you provide is to show 3 results per row, as opposed to just one. If you only want one result per row this can be simplified greatly to:

<?php

$q = mysql_query("SELECT username, user_id FROM user") or die(mysql_error());

echo"
<table>
<tr>
<th> user id</th>
<th> username</th>
</tr>";

while($row = mysql_fetch_array($q)){
	extract($row);

echo "<tr>
<td>$user_id</td>
<td>$username</td>
</tr>";
}
echo"</table>";
?>

[php1306]

thanks a mil! i think i've just been staring at it for so long i need someone fresh to look at it.