RE: [PHP] MSSQL Function like mysql_insert_id?
| From: | Flint Doungchak | Date: | Thu, 20 Jul 2000 00:30:15 +0000 |
| Subject: | RE: [PHP] MSSQL Function like mysql_insert_id? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-7364@lists.php.net to get a copy of this message | ||
Answered my own question.
If anyone if wondering,
add SELECT @@IDENTITY to your INSERT statement and you'll get the id.
Thanks.
Flint
> -----Original Message-----
> From: Flint Doungchak [mailto:Flint@netsolutionsllc.com]
> Sent: Wednesday, July 19, 2000 5:15 PM
> To: 'php-general@lists.php.net'
> Subject: [PHP] MSSQL Function like mysql_insert_id?
>
>
> Is there a way to pull out the last auto_increment id of a
> insert statement in
> MSSQL like the one that is avaliable for MySQL (namely
> mysql_insert_id)?
>
> I'm inserting a record and would like to know the value of
> the unique key so I
> can pass that to another page right away.
>
> Thanks,
>
>
> ________________________________________________
> Flint Doungchak
> Web Applications Developer
> Net Solutions LLC
> 840 Lawrence Street
> Eugene, OR 97401
> VOICE (541) 345-7087 FAX (541) 485-5519
> flint@netsolutionsllc.com
> www.netsolutionsllc.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>