I have a php/mysql database with articles. What I need is a php sctipt or
some mysql that will compare the current day with the 'expiry date'
entered by the user and if the there is a difference then drop it from the
database..
I am fairly new to mysql so do not know if there is
a way to automatically drop records when they expire.
I retrieve the date (called time) and format it like this...
$query= "SELECT DATE_FORMAT(time, '%d.%m.%Y') AS time, article, id FROM
news ORDER BY id DESC";
The expiry date is entered through a _javascript_ widget and is in the format
dd/mm/yyyy.
thanks,
Ross
|
- setting expiry date ross