I'm creating a rank system and ranks are stored in a database, my problem is about finding rows with greater or equal value to given user xp:
It's something like this:
list of ranks in ranks table:
name: Rank1 exp: 400
name: Rank2 exp: 500
name: Rank3 exp: 700
$xp = "500";
$find = $db->query("SELECT * FROM ranks WHERE exp >= '$xp' LIMIT 1");
if($find->num_rows > 0){
// if a rank with greater than or equal value was found
$rdata = $find->fetch_assoc();
// return rank name
echo $rdata["name"];
}
this returns Rank1, i don't know why :(
Can anyone help me? I'm not yet good in mysql.