Jump to content

Archived

This topic is now archived and is closed to further replies.

frescue33

Auto delete row after event date has passed

Recommended Posts

I have a table i am using to pull event information from to list upcoming events. Among others the table contains a 'startdate' and 'enddate' column (allowing for multiple day events). With each event being a new row. I was thinking something allong the lines of: IF currentdate > enddate DELETE row... But I am new to PHP so I have no idea how to script this part of the event manager. Any and all help would be appreciated.

Share this post


Link to post
Share on other sites
[code]mysql_query("DELETE FROM event_table WHERE enddate < CURDATE()";[/code]

Share this post


Link to post
Share on other sites
It's a MySQL date function. It returns the current date in YYYY-MM-DD format.
[a href=\"http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.1/en/dat...-functions.html[/a]

If you need a unix timestamp, use UNIX_TIMESTAMP() instead.
(same page, lower down)

Share this post


Link to post
Share on other sites
DATE format.

$res = mysql_query("SELECT CURDATE()");
echo mysql_result($res,0); // ----> 2006-06-26

Share this post


Link to post
Share on other sites
Oh ok, thought so. Just making sure I haven't been typing extra code all this time, haha.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.