Ok im not sure wether this counts as a php question or a database question, but ill put it here anyway.

I have two fields in a database, one of which holds a foreign key that is a primary key from the other:
USER(user_ID, username, password)
USER_INFORMATION(user_info_ID, user_ID, name, DOB, email, address)

when i put data into the database from a form on a page, how can i make it so that the right user_ID goes into the USER_INFORMATION table.

Hope i put that clear enough

10 Years
Discussion Span
Last Post by hooray

I forgot to mention before that user_ID is set to auto_increment in the USER table


Do a SELECT to find the user_id for the current user in the USER table. Assign the user_ID to a variable, $user_ID. Now do your UPDATE on the USER_INFORMATION table using WHERE user_ID='$user_ID'

Votes + Comments
good solution
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.