Suggestions - Delete Row At Specific Time

[stormx]

I have no clue where to start but would anyone have any suggestions on a PHP script that gets a specific date from a MySQL database table, and when the date comes the cron will delete the nominated MySQL row.

 

If you didn't quite understand what I mean, here is another example:

 

Cron >> Gets specific date from MySQL row >> If that date is the same as today’s date it will delete the row.

 

I have no clue where to start and I am very new to PHP, could anyone give an example PHP script or a recommendation.

 

Thanks

[AjBaz100]

** Gets specific date from MySQL row  ***

How is this specific date determined.

 

Basically you could create a SQL file with the query, then put this in your cron

 

* 5 * * *  user mysql -u xx -p xx -h somehost.com database < query.sql

 

query would look like this

delete from table where fieldname >= curdate() and fieldname <= curdate()

[fenway]

The cron can't check a mysql table before it runs ;-)

 

Run a daily job, have that job run a script that deletes the marked row.