4 replies to this topic

[Lang]

Hey,

I know rc69 is really good with this. I hope he's got an answer.

Anyways, so I have a table built like such

ID | Info

1 Blah
2 Poo!


So, I'm going to insert another row

INSERT INTO table (info) VALUES ('w00t')

Now, what I'd like to know how to return the inserted row ID for the ID field. So the next should be 3 but I want to return this number to me. But it may not be 3 in some cases (if I deleted a row) so it could be 4. I just want it to return the inserted row ID.


Hope I explained it well,
Thanks in advance

[rc69]

If you wanted my help specifically you coulda pm'd me

http://dev.mysql.com/doc/refman/4.1/en/get...-unique-id.html
I'm out of time right now, and out for the weekend, so the only other advice i can give is to do a forum search, this has been asked before i believe.

[Hayden]

well, one thing to note is that if the id is your primary key, as most tables should have, you don't want the id's reused after they've been deleted. it's bad database design. it's better to just let the database auto-assign the primary key ID so that each entry gets its own unique ID.

[liveman]

SpaceGhost, on May 6 2006, 03:40 AM, said:

well, one thing to note is that if the id is your primary key, as most tables should have, you don't want the id's reused after they've been deleted. it's bad database design. it's better to just let the database auto-assign the primary key ID so that each entry gets its own unique ID.

He knows that, and he has that but if you delete a row for some un knownreason the autu-assign won't go back to the missing ID anyhow http://us2.php.net/m...l-insert-id.php is what you are looking for

[Lang]

Thanks liveman. Yes I had a friend point out the function and I slapped myself several times.