How do I combine INSERT & SELECT statements?

[patelxxx]

In the following mySQL code:

INSERT INTO comments 
(relateditemtype,relateditemid,region_id, 
user_id, comment_text,dateadded)            
VALUES (?,?,?,?,?,NOW())

I want to 'add' another field (company) from another table (account table), how do I this?

Thank you

RP

[r035198x]

In the following mySQL code:

INSERT INTO comments
(relateditemtype,relateditemid,region_id,
user_id, comment_text,dateadded)
VALUES (?,?,?,?,?,NOW())

I want to 'add' another field (company) from another table (account table), how do I this?

Thank you

RP

I don't get your problem completely. Perhaps if you can clarify the following?
Do you have a column called company on the comments table?
If you do, what's your rule for setting a compay in that table? i.e How do you determine which company is set for which row in the comments table.