mysql INSERT from multiple sources

[sunfighter]

This should be simple, I want to insert data into a single table from a second table AND a FORM.

 

The FORM  is a textarea string. The submit button starts the INSERT INTO request (A DATABASE), but I want to include two columns from a second database called members. The two columns in members is name and id.

 

so the query looks like : INSERT INTO request ( text, name, id) FROM ---  how do I do that VALUES ($message) VALUES (name,id) FROM members......??

[Pikachu2000]

OK, but how are you going to determine which record's name and id field should be used? You should already have selected the record somewhere, no?