[kavionly]

Hi,
How do i send an auto email reminders to specified email address at a certain date and time, date time and email from mysql database.

can anyone help me pls?

Thank You,

[dgreenhouse]

Here's a "quick and dirty" "text-only" emailer...
HTML and/or multi-part emails will take more work...

As far as the time and date, you can setup a cron job that runs the php script at the appropriate times. If there are datetime reminders on a "per email recipient" basis, you'd need 1 or more additional fields in the database to limit the sql selection on.

Code:

$db = mysql_connect('host','dbuser','dbpass');
mysql_select_db('some_database');
$sql = "SELECT name,email_addr from users";
$rs = mysql_query($sql);

while ($row = mysql_fetch_assoc($rs)) {
  $to =  "'" . $row['name'] . "' <" . $row['email_addr'] . ">";
  $subject = "RE: The subject";
  $message = "Your message goes here";
  $headers = 'From: info@mysite.com' . "\r\n" .
     'Reply-To: info@mysite.com' . "\r\n" .
     'X-Mailer: AnythingYouWant.0' ;

  // Assuming you have a properly setup mail connection at your hosting account
  $success = mail($to, $subject, $message, $headers);

  // Check $success and process accordingly
}