Web Analytics Made Easy -
StatCounter Between - CodingForum

Announcement

Collapse
No announcement yet.

Between

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Between

    Code:
    SELECT * FROM Bookings WHERE PropertyID = 1 AND ((StartDate BETWEEN 1122854400 AND 1125532799 )OR (EndDate BETWEEN 1122854400 AND 1125532799))
    Thats my SQL statement, this is my enddate 1124037406 which unless my maths is failing me, is between the 2 values but my sql query returns no results...
    http://www.hazelryan.co.uk

  • #2
    That should be working. Are you sure PropertyID is 1?

    Comment


    • #3
      that was the problem, the $ID was being overwritten... oops
      http://www.hazelryan.co.uk

      Comment

      Working...
      X