remove row mysql

[dezkit]

hello, i have a field in my mysql called date,

 

i want to do so that when the current date is equal to the date in the field, the row will be automatically deleted, how do i do this?

 

the date is like "j/d/y"

 

thank you

[Garethp]

$date = date("j/d/y");

// Use http://php.net/manual/en/function.date.php to make it the right format

mysql_query("DELETE FROM `tablename` WHERE `rowname`='$date');

[joel24]

... do you want it removed when something in the database is updated? or when a page is viewed? or automatically at 12:01am?

[dezkit]

... do you want it removed when something in the database is updated? or when a page is viewed? or automatically at 12:01am?

automatically at 12:01am

thanks

[joel24]

then you can use the mysql event feature if your using mysql 5.1.6 or greater

http://dev.mysql.com/tech-resources/articles/event-feature.html

 

or you can set up a cronjob which will run a script automatically at 12.01am every morning...

http://articles.sitepoint.com/article/introducing-cron