Results 1 to 2 of 2

Thread: How to find time range in mysql table with same day

  1. #1
    Join Date
    Feb 2012

    How to find time range in mysql table with same day

    I have a time stored in table 8:00AM-9:30AM TTH . I want to check time range, if user selected 9:00am-10:30am Thursday comes in between time 8:00AM -9:30PM? How to trap it out in php.

    Time is stored in table as below

    Time Day
    8:00AM -9:30AM TTH
    10:30AM -12:00PM MW
    1:00PM -2:30PM MW
    10:30AM -12:00PM FW

    help me please this is my one of my error trap in my thesis project

    thank you in advance

  2. #2
    Join Date
    Dec 2011
    You should be using yer DB's DATETIME/DATE/TIME field types, making expressions with time easier. Your way, you will need to probably create a php function and check each record.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center