Re: [PHP] Check time in between times

2008-02-18 Thread Nick Stinemates
Richard Lynch wrote: > On Sat, February 16, 2008 11:53 pm, Johny Burns wrote: > >> I am having fields in my table where I put times like 4:30pm in string >> format >> > > This is your first mistake... > > Use time fields for time, so you can do time operations on time fields. > > Otherwise,

Re: [PHP] Check time in between times

2008-02-18 Thread Richard Lynch
On Sat, February 16, 2008 11:53 pm, Johny Burns wrote: > I am having fields in my table where I put times like 4:30pm in string > format This is your first mistake... Use time fields for time, so you can do time operations on time fields. Otherwise, you are just re-inventing the wheel and re-wri

Re: [PHP] Check time in between times

2008-02-16 Thread Emilio Astarita
"Johny Burns" <[EMAIL PROTECTED]> writes: > I am having fields in my table where I put times like 4:30pm in string > format Check this: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html Perhaps you could use a data type date for that. > Can anybody help with function which hel

Re: [PHP] Check time in between times

2008-02-16 Thread Nathan Nobbe
On Feb 17, 2008 12:53 AM, Johny Burns <[EMAIL PROTECTED]> wrote: > I am having fields in my table where I put times like 4:30pm in string > format > > Can anybody help with function which helps detect. > Is it the current time between those fields? > > function checkinzone($time1,$time2):boolean