Get Rank by points!

[Jumpy09]

$rankcheck = mysql_query("SELECT r.titlem FROM users as u,rank as r WHERE u.points >= r.pointsreq AND u.uid = '$uid'");
$row = @mysql_fetch_array($rankcheck);
$rank=$row['titlem'];

 

0 Points = Unknown

100 Points = Traveler

 

It's showing Unknown even if I have 101 points.  But it works, in a way.

 

Is there any way to make this pull a user's rank title by how many points they have?

 

Thanks in advance for the help.

[Andy-H]

$rankcheck = mysql_query("SELECT r.titlem FROM users as u,rank as r WHERE u.points >= r.pointsreq AND u.uid = '$uid' ORDER BY r.pointsreq DESC LIMIT 1");
$row       = @mysql_fetch_assoc($rankcheck);
$rank      = $row['titlem'];

 

??

[Jumpy09]

Sweet that works!

 

Thanks!

 

 

Also thanks for the tidying up!  I've never seen that before, I've got to start using it.

[Andy-H]

No problem, glad I could help.