Msg#: 4190188 posted 1:42 pm on Aug 21, 2010 (gmt 0)
Is it possible to check a mysql database value once a day with a cron job and using php change it if true?
Basically when someone enters an item into the database it is assigned a 'type' value of '1' (items are usually listed for 12 months). The user of the item may make it 'Featured' at any time for 1 month or 3 months, which assigns it a 'type' value of '2'.
Once the 1 or 3 month 'Featured' is over I want to convert the 'type' value back to 1 in the database but at the moment it is staying at '2'.
I would like to run a cron job - once a day to check that if the 'Featured date end' is less than today - change 'type' value back to '1'.
Would I get the cron job to run some kind of php script to change the value? Any help appreciated!