sending message to every 1 in my db

[runnerjp]

how could i send a prive message to every 1 in my db?

 

so $reciever = everyone

[prcollin]

how could i send a prive message to every 1 in my db?

 

so $reciever = everyone

 

//Select the "email" column from the table or whatever you named it

$query = "SELECT email from Table";

 

//Then loop through all emails while there are emails to loop through

$result = mysql_query($query) or die("Error in query: $query. ".mysql_error());

while ($row = mysql_fetch_assoc($result))

{

// create the email function

   $email = $row['email'];
    echo "$email<br />";
    $headers .= "Bcc: $email\n";
}

 

 

or somethign to that effect

[.josh]

^ depends on how many emails you are sending you might need to break it down into bite-sized chunks so your script don't timeout.

[prcollin]

maybe do this instead of what i said for the last part in my first response

 

// parts of the email you might want to add

$to = $row[$row_email];
$subject "WHATEVER YOU WANT";
$header = "From: $from (Need to define this variable)";
$body = "what you want to say\n";

 

//mail function to send it off

mail($to, $subject, $body, $header);

[prcollin]

^ depends on how many emails you are sending you might need to break it down into bite-sized chunks so your script don't timeout.

 

ive never had that problem so i dont know how to break it down care to elaborate please?

[.josh]

well if you are only sending a couple of emails then your script will process it in time but if you have like hundreds or thousands of emails, you're script is going to timeout because it will take too long to send all those emails.  So you would break the email list down into smaller chunks and send them 1 chunk at a time.

[prcollin]

well if you are only sending a couple of emails then your script will process it in time but if you have like hundreds or thousands of emails, you're script is going to timeout because it will take too long to send all those emails.  So you would break the email list down into smaller chunks and send them 1 chunk at a time.

 

oh ok i get what you mean do it for like 5 rows at a time and repeat

[.josh]

yeah...well, you can do more than that. Like 20-50.  Guess it really depends on your server.

[prcollin]

yeah...well, you can do more than that. Like 20-50.  Guess it really depends on your server.

 

 

how would i append my code to allow that

i cant find it on google

[runnerjp]

i looked on google to break it down but also can find it any where... thanks for ino tho thats very simple indeed and didnt even think of that lol