help with code.

[seany123]

im trying to make a mass mail page wher i can mass mail everyone but im not too sure how to do it...

 

this is what i would do to message 1 person.

 

$query = $db->execute("insert into `mail` (`to`, `from`, `body`, `subject`) values (?, ?, ?, ?)", array($insert['to'], $insert['from'], $insert['body'], $insert['subject']));

 

the members are stored in member table

 

so basically what i think  need to do is:

 

$query = $db->execute("SELECT id FROM members");

$member = $query->fetchrow(){

$query = $db->execute("insert into `mail` (`to`, `from`, `body`, `subject`) values (?, ?, ?, ?)", array($member, $insert['from'], $insert['body'], $insert['subject']));

}

 

is that right?

 

[trq]

Surely you will need to loop through the results of your query.

[seany123]

$query = $db->execute("SELECT id FROM members");

while($member = $query->fetchrow()){

$query = $db->execute("insert into `mail` (`to`, `from`, `body`, `subject`) values (?, ?, ?, ?)", array($member, $insert['from'], $insert['body'], $insert['subject']));

}

??

[trq]

Even then, I would assume $member is an array.

 

Try...

 

$query = $db->execute("insert into `mail` (`to`, `from`, `body`, `subject`) values (?, ?, ?, ?)", array($member['id'], $insert['from'], $insert['body'], $insert['subject']));