Reminder

[jacrewq]

I want to create a reminder script and I'm looking for a way to initate events. One way is to make CRON jobs for every event but I dont want to use that b/c it takes up resources.

Does anyone know another way to initiate an event at a certain time besides cron?😕

[rIkLuNd]

Well, you could have a field named "time" in your db, and then put this script on the page where you want to execute the event.

## connection here ##

$query = "select * from events";
$sql = mysql_query($query) or die(mysql_error());

$data = mysql_fetch_array($sql));

if($data['time'] < time())
{
   # execution #
}

[jacrewq]

Yes but if an event must occur on Jan 30 at 5:20 how can I start the script at that certain time?