[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() "; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
