SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Querry a database using time stamp

    Hey people's,

    Ok... I need to query my database to look for events that have yet to happen. The database is filled with events from the past to future upcoming events. The ones that are currently going on and one that have yet to happen need to be displayed on one page. The old events need to be place on a page that will be set a side for archiving.

    I did some research in into timestamping in php. Where do I start from here. What function would I use to ask the database to compare the current time stamp to the date of the event.

    Thanks

    -akp

  2. #2
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    How do you store the dates in your database?

    Are they timestamps too?

    Show the table schema if you can.

  3. #3
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The date is a string but the deadline is in date form. The attachment is the table
    Attached Files Attached Files


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
  •