Re: FN-FORUM mysql date delete

date posted 27th June 2002 16:17

> I have 2 fields in a mysql database. One is the start date of an event
> called 'start' and one is the end date of an event called 'end'
>
> I want to make the database delete entries automatically when the 'end' date
> is greater than the system date.
>
> I use php as a front end.
>
> how would you go about this utilising either php or mysql?

Hi Rob,

Step one. Write a PHP script which does the following.

Get todays date from the server.

$today = date("Ymd", time());

// gives a date in the format YYYYMMDD

Delete from the table where end