some everyday mysql database tasks for updating
I have run the script from a browser window and it works
however I tried doing a cron and I am not getting an email
to tell me the cron has been done and looking at the site it
looks like it hasn't been used.
I have tried both of these in my cron set up:
php -q /home/XXXXXX/public_html/cron_XXXXXX.php > /dev/null
I set the cron job to run at:
every other hour
Niether appear to be working.
This is a short excert from the script:
mysql_query("UPDATE `XXXXXX`.`XXXXX` SET `intCategory` = '131' WHERE `intAuthorId` =39930
AND `intStatus` =0")
mysql_query("DELETE FROM `XXXXXX`
WHERE `textArticleText` LIKE CONVERT( _utf8 '%www.%'
USING latin1 )
As I say the script works OK from a browser window so has anyone any idea
what I may be doing wrong.
Any help much appreciated.