3 Replies Latest reply on Oct 24, 2007 7:44 PM by (Steve_Guluk)

    Auto-expire from query based on date

      I have some records in my MySQL db that contain dates for upcoming events.. I need a way to query upcoming events and expire them from the query once the date passes without necessarily deleting them from the database. (I'm publishing the next 5 upcoming events to the homepage via 'LIMIT 5').

      Is there an easy way to do this within a MySQL db query? This section of the site (both insert record, display, current query, etc) is all created with ADDT.

      Please let me know!