Jump to content


This topic is now archived and is closed to further replies.


Assigning Ranks To Rows (MySQL/PHP) PLEASE HELP

Recommended Posts

Okay, I am trying to creating a ranking list based on total number of points. I have my page set up, and I\'m trying to figure out how to make it say \"1st Place\", etc. Here is my page so far: http://members.lycos.co.uk/triphis/ and im TRYING to get it like this: http://neoguide.dcwd.biz/Pet.asp I asked the owner of that site, but obviously she replied with an ASP command (Counter)... so how do you do it in PHP? Thank you :)

Share this post

Link to post
Share on other sites

Sort the results in descending order based on points.


$query = "ALTER TABLE tablename ORDER BY points DESC"; 

$result = mysql_query($query);


Then get the data like this

$query = "SELECT * FROM tablename"; 

$result = mysql_query($query); 

while($row = mysql_fetch_array($result)){

if($count=="") {$count=1;}

else {$count = $count+1;}

echo("This is ".$count." with ".$row[points]."<br>");



This should repeat for every entry in your table.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.