Insert into all

[onthespot]

Hey guys, I have a question.

I have two tables.

User and Messages.

What SQL would I need to take all users from the user tables and message them all?

Like the messages have to_user, and that needs to be every user from the user table.

Am just trying to create a mass PM function.

Thankyou

[Pickle]

are you saying that you want to take the users from the user table and message them all the same message? or does the message table hold a message unique for each user in the user table?

[onthespot]

Sorry yes message them the same message.

Just a message to all the user basically.

The same message as a MASS pm

[gevans]

I'd go about it this way...

 

$query = "SELECT `user_id` FROM `User`";
$result = mysql_query($query);

while($data = mysql_fetch_assoc($result))
{
mysql_query("INSERT INTO `Messages` VALUES('{$data['user_id']}', 'the message', 'other stuff')");
}

 

You will need to play with this, but it's generally right.

[onthespot]

Yeah thats what i was expecting, something like that.

I will play around with the values and that should work, thankyou