#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    Minneapolis, MN
    Posts
    48
    Rep Power
    15
    I'm working on a webpage that i would like to have autogenerated content, using PHP3 and MySQL. Basically, I would like it to pull information out of the database and post the date and title for the event, based on the current date on the server.
    Does anyone know of a place where I could see this done? or have any sample code i could look at?
    thanks,
    dave.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 1999
    Location
    Annapolis, Maryland US
    Posts
    113
    Rep Power
    16
    >select event_title, event_date
    >FROM event_table
    >WHERE to_days(now()) - to_days(event_date)=0

    // [ORDER BY event_title|event_date] or whatever....

    Assuming the event_date column is a valid date, time or timestamp datatype

Similar Threads

  1. inserting date to mysql db
    By bulletz in forum ASP Programming
    Replies: 3
    Last Post: December 22nd, 2003, 08:13 PM
  2. mySQL date messing with my searches
    By SuperFunHAppyGy in forum MySQL Help
    Replies: 0
    Last Post: December 5th, 2003, 02:31 PM
  3. Replies: 1
    Last Post: October 29th, 2003, 02:34 AM
  4. PHP's date() - not in sync - mySQL now()
    By please_explain in forum PHP Development
    Replies: 1
    Last Post: October 26th, 2003, 04:16 PM
  5. entering date into mysql
    By exolution in forum PHP Development
    Replies: 6
    Last Post: June 25th, 2003, 04:32 PM

IMN logo majestic logo threadwatch logo seochat tools logo