[Resolved] Rank (Order, Auto #)

erikhillis

I was wondering how I go about numbering results... like for example...

I have a ranking system. I want the top10 $x(whatever) to be show, and their rank to be shown aswell...

like for example.

1 - Joe (500 points)
2 - Jay (499 points)

I just want the number they appear from my query which will be:

SELECT * from players order by points desc limit 2

In my code, how would I make it so that it auto numbers the players based on their points (highest = 1), without manually creating a field that sais "rank" and having to go through all my players manually ranking them.

Thx.

olaf

just use a loop:

for ($i = 1; $<$num_rows; $i++) {
echo $i;
}

erikhillis

Where would I insert that in my code... this dosnt seem to work 🙂

<?php 

// Database Connection 
$db = mysql_connect("localhost","***","***");
mysql_select_db (***);

$sql = mysql_query("SELECT * FROM squads ORDER BY points desc LIMIT 20");

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

for ($i = 1; $<$num_rows; $i++) { 
echo $i; 
}

   echo "<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td width=40%><font face=Verdana size=1 color=#736f5e>&nbsp;<B>»&nbsp;</B><font face=Verdana size=1 color=FFFFFF> $i - <a href=squad.php?userid=".$row["userid"].">".$row["squad_name"]." </a></td>
<td width=15%><font face=Verdana size=1 color=#ffffff><center>".$row["points"]."</td>
<td width=15%><font face=Verdana size=1 color=#ffffff><center>".$row["win"]."</td>
<td width=15%><font face=Verdana size=1 color=#ffffff><center>".$row["loss"]."</td>
<td width=15%><font face=Verdana size=1 color=#ffffff><center><img src=images/".$row["trend"].".gif></td></tr>
</table>";
 } 
}
?>

bubblenut

The idea is you retrive the number of rows from the query, however you can integrate retrieving data from the database with a for loop (using the $row=mysql_fetch_array the condition as shown below. What it is doing is incrimenting the counter $i every time a new row is retrieved from the database.

for($i=1;$row=mysql_fetch_array($sql);$i++) {
  echo('<tr><td>'.$i.'</td><td>'.$row['userid'].'</td><td>'.$row['squad_name'].'</td></tr>');
}

HTH
Bubble

erikhillis

Thx, got it figured out 😃