[Resolved] making a cron job

[gregorya]

How do i turn the following code into a cron job that runs automatically?

<?
$day=date(j);
$month=date(n);
if($day=1)
{
include("file:///C|/Documents%20and%20Settings/Owner/My%20Documents/play%20havasu/_includes/db_fns.php");
$db=db_connect();
$table=$month-1;
$sql="TRUNCATE TABLE $table"
mysql_query($sql) or die("Error");
}
else
echo "hello it is".date(l,f,Y);
?>

[drawmack]

add it to your crontab

[nemonoman]

Cron jobs are set up as a server function.

If you have a control panel to your server, that would be the easiest way to create the cron job. If you are on a shared server, you may have to ask your provider to create the job for you.

If you do it yourself, you'll need to provide the ABSOLUTE PATH to the cron script.

to find it:

<? echo $_SERVER["DOCUMENT_ROOT"] ; ?>

[gregorya]

Thanks guys I figured it out. I just had to save it in a certain directory. I thought because it was telling me that it couldn't find a cron job script that it just wasn't regognizing it, and I need to have it in a certain language, but I got it all working now. thanks

[gregorya]

Thanks guys I figured it out. I just had to save it in a certain directory. I thought because it was telling me that it couldn't find a cron job script that it just wasn't regognizing it, and I need to have it in a certain language, but I got it all working now. thanks