select LAST record ONLY

[Fritz]

How does one specify (in a select statement) the return of the highest number in a field? or say the LAST record submitted?

Yes, I can select all, reverse sort by record id and LIMIT 1 BUT that seems like the long way.

[toma42]

$max = $db->getOne('select max(table_key) from table');
$row = $db->getRow("select * from table where table_key = $max");