Jump to content

Archived

This topic is now archived and is closed to further replies.

lutzlutz896

Inserting Primary ID into another table

Recommended Posts

I have been trying to figure this out, but can't seem to comprehend how it is done. I know how to use a form to insert data into a database table, and have that table create a unique ID (primary key). My problem is that once the user signs up and creates an account, there is another form in which they will fill out to list their products on the website. Of course the second form stores information into a different table. What I can't figure out is how to pass the primary key from one table, to another table, so that the two tables will be connected.

I know that the user can't possibly enter in the information, because they don't know what thier unique ID is since that is created by the database itself. I'm not sure how this is done, but I know that I need the unique ID from one table to be inserted into the other table so that it corresponds with the correct user. I have been looking through PHP books, but I can't find any information on how to do this. Any help would be much appreciated.

Thanks,

Jonathan

Share this post


Link to post
Share on other sites
When you do your new user insert, right after running that query use...

[code]$user_id = mysql_insert_id();[/code]

Then use that variable to do the other table insert!


me!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.