定时是用linux的cron定时读这个页面脚本,更新就是在SQL之后吧,我不知道应该写在哪啊
$db=mysql_connect('localhost','root','');
mysql_select_db('crm',$db);
$sql="select tt,aa,emgmail,bb,name from table";
mysql_query("set names gb2312");
$result=mysql_query($sql,$db);
while ($row = mysql_fetch_array($result))
{
if($datesy==$row[0] ¦ ¦ $datesy==$row[1])
{
$db=mysql_connect('localhost','root','');
mysql_select_db('crm',$db);
$sql="select tt,aa,emgmail,bb,name from table";
mysql_query("set names gb2312");
$result=mysql_query($sql,$db);
while ($row = mysql_fetch_array($result))
{
if($datesy==$row[0] ¦ ¦ $datesy==$row[1])
{
if(!$mail->Send())
{
echo "Message could not be sent. <p>";
echo "Mailer Error: " . $mail->ErrorInfo;
exit;
}else{
$update_sql = "update table set flag=1 where emgmail='".$row['emgmail']."'";
mysql_query($update_sql);
}