|
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() ";
Navigation:
[Reply to this message]
|