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 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. Link to comment https://forums.phpfreaks.com/topic/216654-select-count-time-overlap/#findComment-1128482 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.