frescue33 Posted June 25, 2006 Share Posted June 25, 2006 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. Link to comment https://forums.phpfreaks.com/topic/12879-auto-delete-row-after-event-date-has-passed/ Share on other sites More sharing options...
Barand Posted June 25, 2006 Share Posted June 25, 2006 [code]mysql_query("DELETE FROM event_table WHERE enddate < CURDATE()";[/code] Link to comment https://forums.phpfreaks.com/topic/12879-auto-delete-row-after-event-date-has-passed/#findComment-49437 Share on other sites More sharing options...
robos99 Posted June 26, 2006 Share Posted June 26, 2006 Is CURDATE a unix timestamp or the MySQL date format? Link to comment https://forums.phpfreaks.com/topic/12879-auto-delete-row-after-event-date-has-passed/#findComment-49543 Share on other sites More sharing options...
johnnyk Posted June 26, 2006 Share Posted June 26, 2006 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) Link to comment https://forums.phpfreaks.com/topic/12879-auto-delete-row-after-event-date-has-passed/#findComment-49546 Share on other sites More sharing options...
Barand Posted June 26, 2006 Share Posted June 26, 2006 DATE format.$res = mysql_query("SELECT CURDATE()");echo mysql_result($res,0); // ----> 2006-06-26 Link to comment https://forums.phpfreaks.com/topic/12879-auto-delete-row-after-event-date-has-passed/#findComment-49547 Share on other sites More sharing options...
robos99 Posted June 26, 2006 Share Posted June 26, 2006 Oh ok, thought so. Just making sure I haven't been typing extra code all this time, haha. Link to comment https://forums.phpfreaks.com/topic/12879-auto-delete-row-after-event-date-has-passed/#findComment-49563 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.