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. Quote 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] Quote 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? Quote 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) Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.