On 25 May 2010 21:09, Bruce Gilbert <webguync@xxxxxxxxx> wrote:
> the resulting output with that code is a little weird. I get September
> 3, 1970 2:39:32pm
>
> I think part of the problem is my Query. When I run it in PHP MyAdmin
> I get a null value for login_timestamp even though there is indeed a
> timestamp there. The Query again is:
>
> SELECT Responses.editor_name,Answer1,Answer2,Answer3,Answer4,Answer5,Answer6,Answer7,Answer8,Answer9,Answer10,Answer11,Answer12,submit_timestamp,login_timestamp
> FROM Responses LEFT JOIN Candidates USING (user_id)
>
> login_timestamp is in a table called 'Candidates' and submit_timestamp
> is in a tables called 'Responses'.
>
> thanks for all the help to this point.
>
> On Tue, May 25, 2010 at 2:28 PM, Ashley Sheridan
> <ash@xxxxxxxxxxxxxxxxxxxx> wrote:
>> On Tue, 2010-05-25 at 14:22 -0400, Bruce Gilbert wrote:
>>> echo "<tr><th>Completion Time:</th></tr><tr><td>". date('F j, Y
>>> g:i:sa',strtotime($row['submit_timestamp']) -
>>> strtotime($row['login_timestamp']))/60 , "</td></tr>";
>>
>> There's a good reason for that! What you're actually doing is this:
>>
>> echo "<tr><th>Completion Time:</th></tr><tr><td>" .
>> date('F j, Y g:i:sa',
>> strtotime($row['submit_timestamp']) -
>> strtotime($row['login_timestamp'])
>> )
>> / 60
>> , "</td></tr>";
>>
>> You're trying to divide a string by 60, because date() returns a string.
>> Put that division inside the brackets for date() rather than outside.
>>
>> It might help to break up that whole line of output into several parts.
>> Put the date into a variable and then just output the HTML line:
>>
>> $date = date('F j, Y g:i:sa', (strtotime($row['submit_timestamp']) -
>> strtotime($row['login_timestamp']))/60);
>> echo "<tr><th>Completion Time:</th></tr><tr><td>$date</td></tr>";
>>
There are two problems you're looking at. The first is the null value
you're getting, which will invalidate the whole thing. The second
problem is that you were looking for output along the lines of "60
minutes" but you're using date() which as the second parameter expects
a unix timestamp - not two timestamps subtracted from each other.
On another note, subtracting the output of two strtotime() calls
inside the date() call doesn't amount to subtracting anything from a
string.
Regards
Peter
--
<hype>
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
</hype>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
