Dynamic DB record creation

[pradeep79]

Hi, I'm creating an application in PHP/MySQL. My problem is I need to create a user account in the DB and then put the primary key of the user, i.e the user ID into various tables as foreign key. How do I write the script? Do I first create the user record in the table and retrieve the ID and insert into other tables with PHP script? Or, could it be done in the database with stored procedures?

[trq]

It would be much more efficient (if your db supports it) to look into triggers.

[Waldir]

INSERT INTO foo (auto,text)VALUES(NULL,'text');

INSERT INTO foo2 (id,text)VALUES(LAST_INSERT_ID(),'text');

 

 

Links for more info and comments:

 

http://www.mysql.com/doc/en/Getting_unique_ID.html

http://www.php.net/mysql_insert_id