help with ranking system, selecting a rank between 2 values

[mattm1712]

hi i have a table like this

 

 

rank        xp

1              0

2            50

3            100

4            200

 

say my username has 75xp how would a select which rank i am

 

not sure how i can do this? :S

 

cheers matt

[haku]

switch(TRUE)
{
  case $xp == 0:
    $rank = 1;
    break;
  case $xp <= 50:
    $rank = 2;
    break;
  case $xp <= 100:
    $rank = 3;
    break;
  case $xp <= 200:
    $rank = 4;
    break;
}

 

$rank will hold your rank.

[xyph]

SELECT `rank` FROM `table` WHERE `xp` > $userXP ORDER BY `xp` DESC LIMIT 1

 

It orders the table from greatest to least XP, then returns the first rank it finds where xp is less than the XP entered.

[mattm1712]

it just echos      Resource id #16  when i use the lastest reply

[xyph]

You need to read up on using MySQL with PHP. You have to parse the result using a mysql_fetch or mysql_result function.