highest value

[darknuke]

how can i find the highest value in a mysql table?

like this:

id | name | description

1 Somesoftware really cool
2 Anothersoftware an amateur work
3 Somegame its nifty

how can i find the highest "id" out of a mysql table like this?

[darknuke]

please help

[winterbeef]

Try this:

$rs = mysql_query("select max(id) as maxid from mytable");
$row = mysql_fetch_assoc($rs);
$max = $row['maxid'];

[darknuke]

:eek: lol... that was easy... THANKS!