Help Quering The Database

[ArmyNation_Net]

Heres' What Im Trying To Do..

Im Trying To Show A Person What Rank They Are Based On a Column Lets Say.

"Mr. Smith, Your Ranked 31st Place In Wealthiest Players!"

Something Like That? Counting The Number Of Rows Ascending On The List He Is Based On a Column (Money).

Anyone Got a Clue?

[leatherback]

try something like:

$basequery = "Select * from RankingTable where money GE MoneyCurrentPerson asc";

$allresults = mysql_query($basequery) or die('Could not get requested information');
    $ReturnedResults = mysql_num_rows($allresults);

mysql_data_seek($allresults, 1) or die("Cannot find result $start: " . mysql_error());

if (!($row = mysql_fetch_assoc($allresults))) 
   {
   // throw error message
   }    

$person = $row['thisperson']

echo "Dear $thisperson, you are number $ReturnedResults";

// added:

Even easier:

use:
Select count(*) from RankingTable where money GE MoneyCurrentPerson asc";

instead

[ArmyNation_Net]

i sorta dont understand it.. im not that suave with My_SQL.

Table: players
column: money
:-D