getting highest id in table

bfsog · 01-17-2005, 08:59 PM

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 · 01-17-2005, 09:07 PM

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

raf · 01-17-2005, 11:41 PM

other option:
select max(id) from tablename

but what do you wanna use it for

bfsog · 04-19-2005, 10:29 AM

Just wanted to know how many rows are in table

NancyJ · 04-19-2005, 11:04 AM

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

Code:

 select count(*) FROM tablename

will tell you how many rows in the table

bfsog · 04-19-2005, 03:06 PM

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.

01-17-2005, 08:59 PM	PM User \| #1
bfsog Regular Coder Join Date: Dec 2002 Location: UK Posts: 180 Thanks: 0 Thanked 0 Times in 0 Posts	getting highest id in table 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

01-17-2005, 09:07 PM	PM User \| #2
Brandoe85 teh Moderatorinator Join Date: Sep 2004 Location: USA Posts: 2,435 Thanks: 2 Thanked 38 Times in 38 Posts	Maybe: SELECT id from tablename order by id DESC limit 1 __________________ -Brando Why using tables for eating is stupid!

01-17-2005, 11:41 PM	PM User \| #3
raf Master Coder Join Date: Jul 2002 Posts: 6,589 Thanks: 0 Thanked 0 Times in 0 Posts	other option: select max(id) from tablename but what do you wanna use it for __________________ Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

04-19-2005, 11:04 AM	PM User \| #5
NancyJ Senior Coder Join Date: Feb 2005 Location: Bradford, UK Posts: 3,051 Thanks: 14 Thanked 61 Times in 60 Posts	What if you delete a record? then the max id will not be the number of rows. Code: select count(*) FROM tablename will tell you how many rows in the table

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

04-19-2005, 10:29 AM	PM User \| #4
bfsog Regular Coder Join Date: Dec 2002 Location: UK Posts: 180 Thanks: 0 Thanked 0 Times in 0 Posts	Just wanted to know how many rows are in table

04-19-2005, 03:06 PM	PM User \| #6
bfsog Regular Coder Join Date: Dec 2002 Location: UK Posts: 180 Thanks: 0 Thanked 0 Times in 0 Posts	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.