<?php
            $dbname = '---';
            $dbuser = '---';
            $dbpass = '---';
            $dbhost = '---';
$server = mysqli_connect($dbname,$dbname, $dbpass);
if (!$server) {
    die(mysql_error());
}
$db =  mysqli_select_db("$dbhost",$server);
// Query for each rank
$qrank1 = mysqli_query("SELECT * FROM `roster` LIMIT 0, 30 WHERE 'rank'=1");
$qrank2 = mysqli_query("SELECT * FROM `roster` LIMIT 0, 30 WHERE 'rank'=2");
$qrank3 = mysqli_query("SELECT * FROM `roster` LIMIT 0, 30 WHERE 'rank'=3");
$qrank4 = mysqli_query("SELECT * FROM `roster` LIMIT 0, 30 WHERE 'rank'=4");
$qrank5 = mysqli_query("SELECT * FROM `roster` LIMIT 0, 30 WHERE 'rank'=5");
$qrank6 = mysqli_query("SELECT * FROM `roster` LIMIT 0, 30 WHERE 'rank'=6");

while($row = mysql_fetch_array($qrank1) {
  echo  "<tr>";
  echo  "<td>Chief of Police</td>";
  echo  "<td></td>";
  echo  "</tr>";
  echo  "<tr>";
  echo  "<td>" . $row['name'] . "</td>";
  echo  "<td>" . $row['Steam UID'] . "</td>";
  echo  "</tr>";

            };
while($row = mysql_fetch_array($qrank2) {
  echo  "<tr>";
  echo  "<td>Captain</td>";
  echo  "<td></td>";
  echo  "</tr>";
  echo  "<tr>";
  echo  "<td>" . $row['name'] . "</td>";
  echo  "<td>" . $row['Steam UID'] . "</td>";
  echo  "</tr>";

            };
?>