Posted by Jay Blanchard on 10/21/54 11:26

[snip]
I have a php/mysql database with articles. What I need is a php sctipt 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 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.
[/snip]

If you want to delete articles whose expiration date is not equal to today's
date;

$sql = "DELETE FROM news WHERE time < NOW() ";

[Back to original message]