get row id back on INSERT?
| From: | Michael Zornek | Date: | Thu, 01 Aug 2002 19:27:35 +0000 |
| Subject: | get row id back on INSERT? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20957@lists.php.net to get a copy of this message | ||
Ok,
So I'm creating the usually MySQL backend....
I have a page that I want to create a new record with some name, then I'd
like to capture the new records id (which is an auto-increment int field) so
I can pass it to the edit.php?id=$theId URL
I could run a reach for the newly inserted row by name .. but that's not
guaranteed to be unique. Maybe name search .. SORT by creation time ? (but
how?)
Any way to do this?
~ Mike
--
Mike Zornek | Project Leader
Apple Student Developers
The Insanely Great Site with the Insanely Long URL
http://www.applestudentdevelopers.org
Personal Site:
http://www.mikezornek.com