[SOLVED] You are...

[paulman888888]

hi,

 

Below is uploadscore.php

<?php
// Insert a row of information into the table "example"
mysql_query("INSERT INTO example 
(name, score) VALUES('" . mysql_real_escape_string($_GET['name']) . "', '" . mysql_real_escape_string($_GET['score']) . "')") 
or die('Theres an error. Please try again.#');  

echo "Score Uploaded!#";
?>

What i would like is a 'You are...' to tell my users which place they came.

 

But i don't know how to order my database to tell me that information.

Please Help

Paul

[FlyingIsFun1217]

As in what url they are on?

 

FlyingIsFun1217

[paulman888888]

as in what place they got in the score list.

i have got in my table

id - name - score

 

and when the score has been submited i want it to show what place they got (NOT THERE ID).

How would i do that?

[GingerRobot]

$sql = mysql_query("SELECT COUNT(*)+1 as rank FROM example WHERE score > ".mysql_real_escape_string($_GET['score'])) or die(mysql_error());
$rank = mysql_result($sql,0);
echo 'Your rank:# '.$rank;

 

[paulman888888]

am i adding this to the code or replaceing it?

[GingerRobot]

What do you think? Take a look at what your current code appears to do and then take a look at what the code i provided appears to do.

[.josh]

If you are wanting the user's score to be added to the database, then you're adding that code to your code as a separate thing.  If you're simply wanting to check the rank against the db, you are changing the code to that.