Scan Database for expired accounts and emial user

[Blay]

Hi,

I have created a site where you need to create and account. What I need to figure out with some major help is......I need to scan all the accounts stored in the database and when the expiry date is 3 days before expiration I want it to email the person and say your account is soon to be expired please renew......etc

Please help me.....

I can't run CRON Jobs....it is being hosted on Windows 2000 Advanced Server / IIS 5.0.

[JerryH]

Well, to automate the process you could probably use Windows' TaskManager to start a Batch file of some sort. I've never used PHP on windows, but I imagine you can call it from the command line.

Just create a regular php script that has all the DB connections and SQL you need to retrieve a dataset.

[Oleg Butuzov]

<?
mysql_connect("localhost", "pejone", "pejone");
mysql_select_db("dreamstan");

$date=date("m-d-y");
$today=explode("-", $date);

$days = date ("Y-m-d", mktime (0,0,0, $today['0'], $today[1]-3, $today[2]));

$query=mysql_query("SELECT * FROM `news` WHERE `date` < '$days' AND `is_1_email_send`= '0' ");

while($data=mysql_fetch_array($query))
{
//dont forget to update your data base
//mail function here "$data[email]";
}

?>

<!--include this script to your index page or some of the most popular/viseted pages =) -->

[Blay]

Thanks for your help!