[SOLVED] newbie question

[uwannadonkey]

there is prolly a simple answer to this:

 

in my game, on the bottom, i wanna do a area where it says: total battles fought

 

i have a table, which stores battle logs with a id, winner, and loser columns

 

how do i grab the row with the biggest ID number(this way, i can use that as battles fought)

[The Little Guy]

Something like this may work:

 

<?php
$sql = mysql_query("SELECT MAX(id) as maxID FROM tbale_name GROUP by id LIMIT 1")or die(mysql_error());
$row = mysql_fetch_array($sql);
echo $row['maxID'];
?>

[uwannadonkey]

now it just says "1"

[uwannadonkey]

fooled with it, and this works:

$sql = mysql_query("SELECT MAX(ID) as maxID FROM battles")or die(mysql_error());

$row = mysql_fetch_array($sql);

echo $row['maxID'];