getting last database entry id

[dux]

Heyho -

little help needed. After adding a database record with the id automatically set - auto incremented - I want to find out what that number is. I can do a dodgy work around but that's simply not good enough for me.

thanks guys 🙂)

[leatherback]

Hi,

THe quick-and-dirty (If you have more then one user updating this is very risky!), prob. needs some comma's etcec:

select * from table sort by ID descending limit 1

Or else: you have probably some unique features: Select for those features, and then get the last record from that. (THat is what I use:

select * from table where SOMECONDITIONS order by ID descending limit 1

Cheers,

J.

[dux]

my mind is changed and I'm now happy 🙂

[blindeddie]

If I were you I would use the following code to get the last inserted id.

$id= mysql_insert_id();

run it immediatly after the insert statement...

it grabs the last generated ID based on the users session, so there can never be a mixup. Just a suggestion

[leatherback]

Also if you do not use sessions on most pages!??

[dux]

even better - thanks!