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.

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
Subject: [PHP-DB] Re: simple database question

oh, using ms sql....

Reply via email to