[RESOLVED] Updating Field with data from another MySQL table

[iHop]

I have a database named traveler. I have two tables in the database: requests and users with a primary field in each "request_id" and "user_id" respectively.

I want to be able to insert a record into the request table. I have my submission form and it works. In my form I select my user from a database menu which enters the "user_id" value.

After I insert my record I want to update the record and I have that form built as well. But here is my problem, I want to be able to automatically update my request record with additional information found in my users record (table). For instance I want the users email to be dropped into my request record.

So I think I should use an "if" statement something like "if user_id is then echo users.email into the requests.email field". I just don't know how to do this.

Please help. Hopefully I have explained this clearly enough. THANKs

[big_nerd]

If I understand you correctly, a good approach would be to grab the data from the existing user record database first (assuming you are taking info from ONE database to put into another).

I.e. SELECT one,two,three FROM users WHERE user_id = '$user_id_from_form';

Then build your insert query from there, you can check if a record has been returned, and validate the data that exists from the users database dynamically (if required).

[iHop]

Cool!!! thanks, sometimes I just can't see what it is that I want to do.
This is what I did:
SELECT request.user_id, user.user_id, user.first_last_name, user.email, user.rank, user.fname
FROM user, request
WHERE user.user_id = request.user_id

Thanks!

[big_nerd]

iHop,

Anytime! Please remember to mark the Thread Resolved (Under Thread Tools) if you feel your issue has been resolved so other users can see this if they are having a similar problem!