[SOLVED] How can i make this show...

[paulman888888]

Does anyone know how i could get this code to tell you where you came?

Eg after score has been submited it will tell you what place you came?

<?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!#";
?>

 

Thankyou

[MadTechie]

heres a quick write up, untested but should work,

<?php
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.#');  

mysql_query("SELECT count(name) as position FROM example WHERE score > ".mysql_real_escape_string($_GET['score'])) or die('Theres an error. Please try again.#');

$row = mysql_fetch_assoc($result);
$position = $row['position']+1;
echo "your Position was ".$row['position']."<br>";
?>