Are you wanting to insert into two tables (messages,
social_networking) with one statement?
If not, an INSERT / SELECT might work well for you. Like so:
INSERT INTO messages
(author, recipient, subject, body, timestamp)
SELECT
1, social_networking.user_id, 'dfdf', 'adfgdf', 1144463208
FROM soc
Hi,
In a messaging system I'm working on, I will allow user's to send the same
identical message to numerous other people. Kind of like in email you can
separate recipients with ";" or use CC.
It would be nice to be able to perform a query like so:
INSERT INTO messages, social_networking (author