On 7 Oct 2008, at 12:48, Jason Pruim wrote:

On Oct 7, 2008, at 7:41 AM, Stut wrote:

On 7 Oct 2008, at 12:38, Jason Pruim wrote:
I am trying to track down an error and can't seem to figure it out... Here is the error out of my log:

[Tue Oct 7 07:31:43 2008] [error] PHP Warning: date() expects parameter 2 to be long, string given in /Volumes/RAIDer/webserver/ Documents/dev/stimecard/timecard.php on line 57


Here is line 57:

$timeout = date("m/d/y h:i:s A", $row['timeout']);


And the info that is trying to grab from the database is:

+------------+------------+-------+--------+-------------------+
| timein     | timeout    | empID | record | Name              |
+------------+------------+-------+--------+-------------------+
| 1222354037 | 1222382837 |     1 |    107 | Jason Pruim       |
+------------+------------+-------+--------+-------------------+

Now... the error only happens on line 57... On line 56 there is the same command except: $timein = date("m/d/y h:i:s A", $row['timein']);

And that doesn't cause any errors so I'm at a bit of a loss as to what to do? I know I can redirect the warning to an error message, but I don't want to do that... I am trying real hard to write clean code... And this is my last error...

It's a total cosmetic thing since it still displays everything right...

Any ideas? :)

Do a var_dump($row['timeout']) on the line before the one giving the warning to check that it contains what you think it does.


Hey Stut,

Thanks for the quick response... You were right... I did a var_dump both on $row['timein'] and $row['timeout'] and the error was because of the way that I update the records. for time in, I insert a new record, for time out, I update the record where timeout= NULL and THAT is what was causing the issue... I guess I can just redirect that error, ignore it, or come up with a different way to update the current record without having to use NULL, or maybe, write a timeout timestamp for like midnight on January 1 1955 or something like that...

Try "is null" rather than "= null".

-Stut

--
http://stut.net/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to