SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    May 2004
    Location
    London
    Posts
    155
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    dates into mysql

    Hi

    I've got several pulldown menus on my page with the idea being that users would select a from and then a to date.

    For example from 22 August 2004 to 4 September 2004 .

    You can see the actual page here My Webpage

    What I need is then a way of getting all the dates that fall in between into one colum into a mysql table. Is there a way of doing it with UNIX_TIMESTAMP() AND BETWEEN

    thanks

  2. #2
    SitePoint Guru
    Join Date
    Jul 2004
    Location
    Raleigh, NC
    Posts
    783
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    use strtotime or mktime then use simple math functions to compare


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
  •