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.
[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: 26 July 2001 15:08
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: simple database question
oh, using ms sql....