[PHP] Date comparison Question

2008-04-07 Thread admin
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 varchar(12). Storing the data they seem to be the same for

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

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 last

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

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 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 CallEnd

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, 2008 at

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 01:45 Works

[PHP] Date Comparison Question

2001-01-26 Thread Martin Fernandez
I'm fairly new to php and still learning it's nuances, etc. I've created a site - http://www.more-mtb.org - in which I have used several php resources from around the net and some which I have created my self. On the home page of the site I have inserted some code that displays a series of