RE: [PHP] Need a function to calculate time difference.

2003-07-04 Thread Boaz Yahav
: [PHP] Need a function to calculate time difference. datetime. Thanks Jim Lucas wrote: >what type of format does your column take? > >date >time >datetime > >?? > >Jim Lucas >- Original Message - >From: "Jack Sasportas" <[EMAIL PR

Re: [PHP] Need a function to calculate time difference.

2003-07-03 Thread Jack Sasportas
datetime. Thanks Jim Lucas wrote: what type of format does your column take? date time datetime ?? Jim Lucas - Original Message - From: "Jack Sasportas" <[EMAIL PROTECTED]> To: "php" <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 2:11 PM S

Re: [PHP] Need a function to calculate time difference.

2003-07-02 Thread Larry R. Sieting
Hi, I just went through this... for my daughters drive time for a level one michigan license. Thanks to Wendell Brown for the help. following is my create table command; CREATE TABLE `mileage` ( `id` int(11) NOT NULL auto_increment, `drive_date` varchar(12) NOT NULL

Re: [PHP] Need a function to calculate time difference.

2003-07-02 Thread Jim Lucas
what type of format does your column take? date time datetime ?? Jim Lucas - Original Message - From: "Jack Sasportas" <[EMAIL PROTECTED]> To: "php" <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 2:11 PM Subject: [PHP] Need a function to calculate

[PHP] Need a function to calculate time difference.

2003-07-02 Thread Jack Sasportas
I am trying to find a function or information on how to properly take a start time and an end time from mysql timestamps in order to calculate time taken. So in theory $endtime-$starttime = timespent. It would be great if this understood that 11:55 pm til 12:10am one day apart only equals 15 mi