hi all
i've got this strange problem
i'm using red hat 9
php5
mysql 4.1.7
i wrote a script to reset some mysql tables and rename them
from the command line
then i put in an executable text file
Code:
cd /usr/bin
php /path/to/resetmonth.php
saved that as resetmonth
i can run it from the command line with ./resetmonth
and the tables update properly
but when i set the cron job as
Code:
0 0 1 * * /path/to/resetmonth
change the date to just before the end of the month
but it doesn't do anything (could it be changing the date like that?)
i have another cron job that runs every day
and uses the same code in the exe text file, and that works
can anyone give me a clue as to what the problem might be
thanks
dave