|
1 2 3 4 5 6 7 |
SELECT * FROM tbl WHERE existing_start BETWEEN $newStart AND $newEnd OR existing_end BETWEEN $newStart AND $newEnd OR $newStart BETWEEN existing_star AND existing_end if (!empty($result)) throw new Exception('We have overlapping') |
http://stackoverflow.com/questions/2545947/mysql-range-date-overlap-check
hi…such a nice link! lista de email lista de email lista de email lista de email lista de email
Hello! Someone in my Myspace group shared this site with us so I came to look it over. I’m definitely loving the information. I’m bookmarking and will be tweeting this to my followers! Superb blog and brilliant design.
I want to to thank you for this fantastic read!! I definitely loved every bit of it.
I have you book-marked to look at new things
you post…