Just realized this probably was a better place to post my situation... So here's the link:

http://p2p.wrox.com/topic.asp?TOPIC_ID=53588

It's basically how to order the results obtained from one table based on data in another table.

try this if this can help:

   $query="SELECT id,levelofaccess, email, division
   FROM personel";
   $divisions=mysql_query($query)or die(mysql_error());
while($row = mysql_fetch_array($divisions)) {
    extract($row);
   $searchperson = $id;

    echo "display statement";

  $queryrank="Select rank_name, division
 FROM rank
  WHERE division = '$searchperson'";
 $divisions1=mysql_query($queryrank)or die(mysql_error());
while($row1 = mysql_fetch_array($divisions1)) {
  extract($row1);

 echo "display";
}
}

Nope, doesn't work. It's alright. I'm going to come up with a dirty solution, and I'll post it here. Hopefully you or somebody else will see my solution and see what I was aiming for. I should have the solution posted up here in within a few days and when that happens, I'll be looking forward to your input.

Thanks for the initial response.