Sorter efter rang

Og hvad hedder rækken der indeholder 6 ?

select * from tb_users where tb_admin='6' order by pro_name

Det burde kunne gøre trikket :)

$sql = "SELECT * FROM tb_users WHERE tb_admin = '6' ORDER BY username ASC";
$res = mysql_query( $sql ) or die (mysql_error());

while($r = mysql_fetch_array($res)) {
      $id = $r["id"];
      $username = $r["username"];
      $tb_admin = $r["tb_admin"];
      $pro_name = $r["pro_name"];
      $pro_age = $r["pro_age "];
      $pro_email = $r["pro_email"];
      $pro_mobil = $r["pro_mobil"];

echo "$id | $username | $tb_admin | $pro_name | $pro_age | $pro_email | $pro_mobil<br>";
}

layout det selv lidt bedere.. :)