[ad_1]
My question is about how to make a ranking system in where for example, 1000-1199 points is Rank C, while 1200-1299 is Rank C+, and also multiple people can get the same rank if they are hovering around those points?
I haven't tried any code yet as I have no idea how to start this and has been searching my ass off for any clue or idea to do it online, and the only thing I know was how to rank them from example 1-10 in a decreasing manner on a table which was this:
if (mysqli_num_rows($result))
while ($row = mysqli_fetch_assoc($result))
echo "<tr>
<td>$rank</td>
<td>$row['firstName'] </td>
<td>$row['score']</td>
<td> </td>
</tr>";
$rank++;
inside a php.
The one at the top though is entirely different to what I want.
Any Ideas would be great, I've been looking on group by function but it kind of is different in sql.
Thanks
[ad_2]
لینک منبع
