Re: [PHP] determining time difference between two timestamp fields.

2010-05-25 Thread Peter Lind
On 25 May 2010 15:55, Bruce Gilbert webgu...@gmail.com wrote: Here is the situation. I have a form which sets a timestamp when a user logs in using UPDATE in SQL. The field is called 'login_timestamp' and is in a table called 'Candidates'. I have another timestamp which is set when a user

Re: [PHP] determining time difference between two timestamp fields.

2010-05-25 Thread Bruce Gilbert
Thanks. I know my syntax isn't quite right, but is this close to what I need to do? echo trthCompletion Time:/th/trtrtd . date('F j, Y g:i:sa', strtotime($row[login_timestamp] - [submit_timestamp])/60) . /td/tr; On Tue, May 25, 2010 at 10:01 AM, Peter Lind peter.e.l...@gmail.com wrote: On 25

Re: [PHP] determining time difference between two timestamp fields.

2010-05-25 Thread Peter Lind
On 25 May 2010 16:14, Bruce Gilbert webgu...@gmail.com wrote: Thanks. I know my syntax isn't quite right, but is this close to what I need to do? echo trthCompletion Time:/th/trtrtd . date('F j, Y g:i:sa', strtotime($row[login_timestamp] - [submit_timestamp])/60) . /td/tr; No. Assuming

Re: [PHP] determining time difference between two timestamp fields.

2010-05-25 Thread Bruce Gilbert
Here is what I currently have. echo trthCompletion Time:/th/trtrtd . (strtotime($row['submit_timestamp']) - strtotime($row['login_timestamp']))/60 , /td/tr; this gives me an output of 21235172.75 not sure what format that is in? I was hoping for something like 60 minutes, 30 minutes etc. Don't

Re: [PHP] determining time difference between two timestamp fields.

2010-05-25 Thread Ashley Sheridan
On Tue, 2010-05-25 at 12:46 -0400, Bruce Gilbert wrote: Here is what I currently have. echo trthCompletion Time:/th/trtrtd . (strtotime($row['submit_timestamp']) - strtotime($row['login_timestamp']))/60 , /td/tr; this gives me an output of 21235172.75 not sure what format that is in?