RE: [PHP-DB] simple database question
| From: | Hoover, Josh | Date: | Thu, 26 Jul 2001 14:25:56 +0000 |
| Subject: | RE: [PHP-DB] simple database question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10802@lists.php.net to get a copy of this message | ||
OK, you're using SQL Server, right? Try executing this statement after you
insert the user and before you try inserting the address record:
select @@identity
That should give you the last inserted id, assuming it's an identity column.
Josh Hoover
KnowledgeStorm, Inc.
jhoover@knowledgestorm.com
Searching for a new IT solution for your company? Need to improve your
product marketing?
Visit KnowledgeStorm at www.knowledgestorm.com to learn how we can simplify
the process for you.
KnowledgeStorm - Your IT Search Starts Here
-----Original Message-----
From: Brian Weisenthal [mailto:bsw10@cornell.edu]
Sent: 26 July 2001 15:08
To: php-db@lists.php.net
Subject: [PHP-DB] Re: simple database question
oh, using ms sql....