SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard PHPycho's Avatar
    Join Date
    Dec 2005
    Posts
    1,201
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to query this??

    Plz help me a bit
    suppose i had the follwing table with values
    id booking_from booking_to status
    1 2007-02-08 2007-02-19 1
    2 2008-03-12 2008-04-22 1
    suppose for the month 2007-02 i had to show the days which has been booked in array..How to perform the query...
    also perform the query for the month 2007-04

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    which database? (none of them support arrays, by the way)

    do you have a calendar table or integers table?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •