Another Quick Question

[paulman888888]

I have my code but i want to show only results with the same gameid and $_get['gameid']

heree is my code that i think i need to edit but dont know how.

$result = mysql_query("SELECT * FROM myscore2 ORDER BY score DESC") 

 

Thankyou

[GingerRobot]

If gameid is an integer:

 

$result = mysql_query("SELECT * FROM myscore2 WHERE gameid=$_GET['gameid'] ORDER BY score DESC") 

 

Otherwise:

 

$result = mysql_query("SELECT * FROM myscore2 WHERE gameid='".$_GET['gameid']."' ORDER BY score DESC") 

[discomatt]

Don't forget to sanitize

 

mysql_real_escape_string($_GET['gameid'])

 

Damn that function name is WAY too long