Re: get row id back on INSERT?
| From: | Jason Wong | Date: | Thu, 01 Aug 2002 19:40:18 +0000 |
| Subject: | Re: get row id back on INSERT? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20958@lists.php.net to get a copy of this message | ||
On Friday 02 August 2002 03:27, Michael Zornek wrote:
> 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?
rtfm ? mysql_insert_id()
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
All the troubles you have will pass away very quickly.
*/