Please Help PHp Database List

Anon

I've imputted information to a database and now I'm displaying that information in a table on a website.
What I'd like to do is have the script number the entries based by score. While I can make it order them by score I don't know how to make it give the same number to entries that are "tied" for points.

IE.
1. Jeff - 10 points
2. Dave - 9 points
3. Carl - 9 Points

I want it to display like this:
1. Jeff - 10 points
2. Dave - 9 points
2. Carl - 9 Points

Can anyone help?

bastien

hey saph.

use a loop and then check the value of the $points in the loops and echo the number

<?
while $row= mysql_fetch_array($result){
$name = $row["name"];
$points = $row["points"];

$x=1; //set the value of the counter
if (!$oldpoints){
$oldpoints=$points;
}
if ($oldpoints == $points){
echo "<tr><td>$x</td><td>$name</td><td>$points</td></tr>";
}else{ //if not $points <> $oldpoints
$x=$x+1;
echo "<tr><td>$x</td><td>$name</td><td>$points</td></tr>";
$oldpoints=$points;
}
} //end the data loop

I have not included the <table> commands

hth

bastien

Anon

you display the results by using a while loop right?

and the counter is increased by 1 when it loops once.

all you need to do is add a "if condition", only when the current record points is different than previous record points, the counter will be increased by 1. otherwise, the counter will stay as the same.