I have a form that users fill in to post their job advertisements and one of the fields they enter is the number of days to keep job 'open'.I want to be able to automatically change the status of the job to 'closed' after the days that they have entered have elapsed.The job table is already set up with status and expiry, I just need to know how to automatically change the status from 'open' to 'closed'.I have little knowledge of MySQL and the queries that I would need to run.
set status on record automatically after certain datetime
- Thread starter waseema
- Start date