Below is some code, it returns no errors but doesnt delete anything from my DB 🙁
<?
function executeQuery($sql)
{
$result = mysql_query($sql) or die("<span style='FONT-SIZE:11px; FONT-COLOR: #000000; font-family=tahoma;'><center>An Internal Error has Occured. Please report following error to the webmaster.<br><br>".$sql."<br><br>".mysql_error()."'</center></FONT>");
return $result;
}
function autodeletemail(){
$sql="select * from friend_mail_details where status='Read' and TO_DAYS(NOW()) - TO_DAYS(date1) >=8";
$result_mail=executequery($sql);
while($line_mail=mysql_fetch_array($result_mail)){
$sql = "delete from friend_mail_setting where mail_id='$line_mail[auto_id]' and (sent='No' and save='No' and inbox='Yes' and trash='No')";
executequery($sql);
}
$sql = "delete from friend_mail_details where status='Read' and TO_DAYS(NOW()) - TO_DAYS(date1) >=8";
executequery($sql);
}
autodeletemail()
?>
