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
www.blue-fly.co.uk | ross@stripped | 07816 996 930 | 0131 553 3935
Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/html]
