MYSQL/PHP Select A Users Ranks

Hi I have A MYSQL Database Thats Like This

|id|username|password|rank  |
|1 | jeff   | Passwor| admin|
|2 | bob    | passow | user |

how would i use php to fetch it and assign it a variable