[SOLVED] Yet another mind blank

[paulman888888]

I would like a script that when loaded shows the highest id

i got this of Madtechic,

WHERE GameID = 1

so i thought if i change it i would get,

WHERE MAX id

echo id

 

But i can't put it into proper PHP script.

[DarkWater]

You don't put it into the PHP script, you put it in the MySQL query.

[.josh]

$r = mysql_query("select max(game_id) from tablenamehere");
$id = mysql_fetch_row($r);

echo $id[0];

[MadTechie]

to get the highesty score for all the games try this

SELECT GameID, MAX(score) FROM scores GROUP BY GameID

 

or for a single game

SELECT GameID, MAX(score) FROM scores WHERE GameID=XX GROUP BY GameID

XX = game ID ie

 

EDIT: Crayon Violent beat me