duda de poder enviar email por fecha

[xoceunder]

ok mira este codigo que encontre pero no me esta funcionando

Código PHP:

<?php
$host = "localhost";
$user = "user_name";
$pass = "password";
$db = "domains";
 
$startdate = date("Y-m-d");
$enunmes = explode ( "-", $startdate );
$sumaunmes = mktime ( 0, 0, 0, date( $enunmes[1]), date($enunmes[2]+ 1), date($enunmes[0]) );
$expiredate = date ("Y-m-d", $sumaunmes);
 
    mysql_connect($host,$user,$pass) or die("ERROR:".mysql_error());
    mysql_select_db($db) or die("ERROR DB:".mysql_error());
    $query="SELECT domain_name FROM domains WHERE exp_date > $expiredate ORDER BY domain_name ASC";
    $result=mysql_query($query);
    $num=mysql_numrows($result);
    mysql_close();
    $i=0;
    while ($i < $num) {
    $id=mysql_result($result,$i,"id");
    $domain_name=mysql_result($result,$i,"domain_name");
    $company_name=mysql_result($result,$i,"company_name");
    $simply_account=mysql_result($result,$i,"simply_account");
    $notes=mysql_result($result,$i,"notes");
    $exp_date=mysql_result($result,$i,"exp_date");
    $to = '[email protected]';
    $subject = 'Domain renewall reminder';
    $message = '
    The following domains will expire in 7 days
    <BR><BR>
    $domain_name - $company_name<BR>
    <BR><BR>
    Dont forget to renew!<BR><BR>
    Domain Team
    ';
    $headers = 'From: [email protected]' . "\r\n" .
    'Reply-To: [email protected]' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();
    mail($to, $subject, $message, $headers);
?>