feha Posted October 23, 2010 Share Posted October 23, 2010 Hi, Im stuck with this and need some help. SELECT COUNT(id) AS counter FROM time_reporter WHERE user_id='$user_id' AND actual_date = '$date' AND ((start_time > '$start_time' AND end_time < '$end_time')) It checks ok if in range but i need to make sure if there is a record start , end time so next record could not be inserted ... if one record has end_time example 22:30 the next record can not have start_time 22:15 etc ... so with this i cant get is count ... any help appreciated Thank You Quote Link to comment https://forums.phpfreaks.com/topic/216654-select-count-time-overlap/ Share on other sites More sharing options...
fenway Posted October 30, 2010 Share Posted October 30, 2010 Sorry, I don't follow. Quote Link to comment https://forums.phpfreaks.com/topic/216654-select-count-time-overlap/#findComment-1128482 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.