getting highest id in table

[bfsog]

I have a table with a column called id, set to autoincrement.
I have a admin section, on that page I want to see what the highest id is.

something like?

SELECT * id FROM table_name WHERE id = max ?

Thanks

[Brandoe85]

Maybe:
SELECT id from tablename order by id DESC limit 1

[raf]

other option:
select max(id) from tablename

but what do you wanna use it for :confused:

[bfsog]

Just wanted to know how many rows are in table

[NancyJ]

What if you delete a record? then the max id will not be the number of rows.

select count(*) FROM tablename

will tell you how many rows in the table

[bfsog]

I thought my previous post might cause a stir, almost.

What I wanted was a way to say
the next post will be number $number

Thanks all.