RE: [PHP-DB] Re: NewB: Return New Record ID...
| From: | USA) | Date: | Thu, 26 Dec 2002 17:06:11 +0000 |
| Subject: | RE: [PHP-DB] Re: NewB: Return New Record ID... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24390@lists.php.net to get a copy of this message | ||
for MS SQL and Oracle does anyone know a more reliable way to do this than select max(ID)
immediately after the insert? It seems silly that I'd have to take my chances that another has
been inserted in between.
<>< Ryan
-----Original Message-----
From: J.Veenhuijsen [mailto:info@solid-digital.nl]
Sent: Friday, December 06, 2002 1:52 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: NewB: Return New Record ID...
Try $last=mysql_insert_id();
Jochem
Doug Coning wrote:
> Hi all,
>
> How do I do this:
>
> I need a PHP page that simply creates a "blank" record so that I have the
> record's ID (which is automatically generated). That same page then needs
> to return the record ID back so that I know what the ID is. I will later
> allow that record's information to be populated based on the ID it first
> returned.
>
> How would I do this?
>
> Thank you, thank you!
>
> Doug Coning
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php