ranking system help

[mike1313]

How can I make it so that I can search a table for example the table named donations where it looks through the table and finds the field dollars and updates the same table but a seperate field named rank and updates that field 1 to whatever number for 1 being the person with the highest donation for example.

 

John donated $3400

Bob donated $3000

Sally donated $50

 

So it would update the field named rank to as follows

 

John - 1

Bob - 2

Sally - 3

 

Any help is very greatly appreciated.

[chigley]

<?php

$query = mysql_query("SELECT name FROM table ORDER BY dollars ASC") or die(mysql_error());

$rank = 1;

while(list($name) = mysql_fetch_row($query)) {
$update = mysql_query("UPDATE table SET rank = {$rank} WHERE name = '{$name}'") or die(mysql_error());
$rank++;

echo "Set {$name}'s rank to {$rank}<br />\n";
}

?>

 

Untested

[jitesh]

No need for RANK Feild.

 

Fetch data by

Dollor Ascending

.

[chigley]

No need for RANK Feild.

 

Fetch data by

Dollor Ascending

.

 

Yeah that's what I thought too..