Ok, hey I have:

Users table:

UserID, Rank, and other user details

Platoon_members:

UserID, and other details.




I have this statement:
Code:
$query = "SELECT * FROM `platoon_members` WHERE `platoon_id` = '{$row[id]}' ORDER BY `rank` ASC ;";
But I need to ORDER BY the rank feild in the users table.
There is no Rank Field in the platoon_members table.

if you dont understand me, ill explain in more detail