Re: [PHP] Date comparison Question

2008-04-07 Thread Daniel Brown
On Mon, Apr 7, 2008 at 1:03 PM, <[EMAIL PROTECTED]> wrote: > Dan I made a solution as below. > > > $time1 = strtotime("$sqldata[CaldTime]"); > $time2 = strtotime("$sqldata[CallEnd]"); > $interval = $time2 - $time1; > $TLength = date("i:s", strtotime("2008-01-01 01:00:$interval")); > > Result

Re: [PHP] Date comparison Question

2008-04-07 Thread admin
Dan I made a solution as below. $time1 = strtotime("$sqldata[CaldTime]"); $time2 = strtotime("$sqldata[CallEnd]"); $interval = $time2 - $time1; $TLength = date("i:s", strtotime("2008-01-01 01:00:$interval")); Result 01:45 Works perfect for me. Do you agree or disagree dan? On Mon, Apr 7, 200

Re: [PHP] Date comparison Question

2008-04-07 Thread Daniel Brown
On Mon, Apr 7, 2008 at 11:42 AM, <[EMAIL PROTECTED]> wrote: > I am having a date time comparison issue. > I have statically set the values here. But the data is fed from the > database, CaldTime is timestamp and since it will not allow me to have 2 > timestamps in the same table I set the CallE

Re: [PHP] Date comparison Question

2008-04-07 Thread admin
Thank you that is exactly what i did to figure it out. Just was having a brain fart there for a minute. On Mon, Apr 7, 2008 at 11:42 AM, <[EMAIL PROTECTED]> wrote: >t the data is fed from the database, CaldTime is timestamp and since it will not allow me to have 2 timestamps in > the same table

Re: [PHP] Date comparison Question

2008-04-07 Thread admin
Yes my mistake was looking at another record and published another. But I figured it out now i can publish 1:45 like i wanted. Having a moment there. Thank you Richard L. Buskirk    On Mon, Apr 7, 2008 at 9:42 AM, <[EMAIL PROTECTED]> wrote: I am having a date time comparison issue. I have st

Re: [PHP] Date comparison Question

2008-04-07 Thread Mark J. Reed
On Mon, Apr 7, 2008 at 11:42 AM, <[EMAIL PROTECTED]> wrote: >t the data is fed from the database, CaldTime is timestamp and since it will not allow me to have 2 timestamps in > the same table ?? What database are you using? It sounds like it has a specific meaning of "timestamp" - probably "the

Re: [PHP] Date comparison Question

2008-04-07 Thread Nathan Nobbe
On Mon, Apr 7, 2008 at 9:42 AM, <[EMAIL PROTECTED]> wrote: > I am having a date time comparison issue. > I have statically set the values here. But the data is fed from the > database, CaldTime is timestamp and since it will not allow me to have 2 > timestamps in the same table I set the CallEnd v

Re: [PHP] Date Comparison Question

2001-01-30 Thread Richard Lynch
> The display works great until I get to the end of the month (like now). I > have separated the date as three rows in my dB (msg_year, msg_month and > msg_day) Don't do that. :-^ > As soon as the next month starts, then I get 4 events. > > I know exactly what's wrong, But my non-programmer limi