Bulk Mail script

[lional]

I would like to have a script where I can pull email addresses from a mysql table, and then either select all of the email addresses or selected email addresses and send a message to them all simultaneously

Any idea where I can get info on such a script

Regards

Lional

[DeathStar]

Use this script:
[code]<?php
session_start();
include "connect";

if($_POST['mes'])
{
$ax=mysql_query("SELECT * FROM users",$c);
while($r=mysql_fetch_array($ax))
{
$to=$r['email'];
$subj = "News from YourSite";
$mess =$_POST['mes'];
$headers ="From: noreply@yoursite.com
";
mail($to,$subj,$mess,$headers);
}
print "Newsletter sent to ".mysql_num_rows($ax)." Users";
}
else
{
print "Send Newsletter to everyone!!.<br />
<form action='nletter.php' method='post'>
<textarea cols=30 rows=15 name='mes'>
</textarea>
<input type='submit' value='Send!'></form>";
}
?>[/code]

[backlund]

Is there a way to do something like this, on scheduled time/days?  I have an event calendar that I would like to be able to email all registered users reminders of the events automatically.  This script takes care of the bulk mailing, but is there a way to schedule it?

[hitman6003]

linux cron jobs or windows scheduled tasks...

[backlund]

Are either of these possible with non dedicated hosting?

[hitman6003]

Depends on your host...you'll have to ask them