[SOLVED] Displaying Rank issues

[Dracolas]

Ok I'm setting up my Memberslist page on my site and i'm using a rank system.

 

I've got the array working... I've got the query working...but when i do

 

$crank = $rank[$row['rank']];
$result = mysql_query("SELECT * FROM users");

while($row = mysql_fetch_assoc($result)){
   echo "<br>Name:".$row['username'];
   echo "<br>Rank: "; echo $crank;
} ;

it only displays the first rank in the database but when I do

while($row = mysql_fetch_assoc($result)){
   echo "<br>Name:".$row['username'];
   echo "<br>Rank: " .$row['rank'];
} ;

it displays each members rank as a number...how do I get it to display using the array with the when...

 

Thank you !

[mikesta707]

in this example

$crank = $rank[$row['rank']];
$result = mysql_query("SELECT * FROM users");

while($row = mysql_fetch_assoc($result)){
   echo "<br>Name:".$row['username'];
   echo "<br>Rank: "; echo $crank;
} ;

 

the crank is only set once. Perhaps you meant to do

$result = mysql_query("SELECT * FROM users");

while($row = mysql_fetch_assoc($result)){
   $crank = $rank[$row['rank']];
   echo "<br>Name:".$row['username'];
   echo "<br>Rank: "; echo $crank;
}//why was there a semi colon here?

[Dracolas]

thank you mikesta707. I tried that and it's working good. The ; is there because I keep in the habit of putting it there so if I put more code below it I don't have to add it later.