Last row only

Can anybody tell me how to call on the last record in a table with auto_increment id?

I tried this:

$sql = "SELECT * FROM inter1 order by id ASC";
$result = mysql_query($sql);	
$r = mysql_fetch_array($result);

This is how I call it:

<? echo $r[id] ?>

I still get 1 when it should by like 26.

Please help.

Sorry, Not last row that would be:

$r = mysql_num_rows($result);

I need the largest id. They wil not always be the same.

SELECT * FROM inter1 ORDER BY id DESC

or if its mysql:
SELECT * FROM inter1 ORDER BY id DESC LIMIT 1

if you just want th highest ID (and no other data)

SELECT MAX(id) AS maxid FROM table;

Thank you Vincent and Brandon!

I need the answer Vincent gave for this problem and the one Brandon gave for another problem I am having. What a Bonus!

Happy Holidays