SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Remove on date

  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2002
    Location
    Australia
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Remove on date

    Hi

    I am making a MySql database to manage events. People who submit events will be able to put in on what date the event is taking place.

    Is there something I can do that once the event has passed ie. the date of the event has passed the event doesn't show on the site anymore. I would like to make this automatic.

    What would be the best way to do this.

    Thanks Alot,
    Ajay

  2. #2
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Compare event date and now() in the sql query you use to select events to show on the site?

    http://www.mysql.com/doc/en/Date_and...functions.html

  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2002
    Location
    Australia
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to compare date

    Could you please tell me how to compare the date using CURRENT_DATE( ) .

    Thanks,

    Ajay
    Last edited by indiaoz; Jun 2, 2003 at 05:59.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •