Re: compare between range

lameck kassana wrote:

hey i have database called timetable in mysql the fields are

 starttime                    endtime
     19                              21
     15                              16

suppose i want to insert want to insert new starttime 17 to endtime 21 from php script .How will try to compare my range with my database range .

To do what? Tell you if a start-time is already taken? Tell you an end-time is already taken? Something else? You need to give us a lot more info. -- Postgresql & php tutorials http://www.designmagick.com/