Storing and retrieving time/date

Anon

I have a MySql db that I use for logging, when I log a event i use the following SQL:

$logtime = time();
#build the sql

$sql = "INSERT INTO log VALUES (NULL, $logtype, '$loguser', '$logip', '$logpage', $logtime )
";

All variables have a value.

When I retrieve the data and try and configure the time, it always comes up with the same date. I use this code to get the Stamp:

#configure date and time
$logtime = $fromlog['time'];
$stamp = date("Hhi I d F",$logtime);

And then echo $stamp. But everytime it shows:

03h14 0 19 January

I have tested that the $logtime variable is being chacnged with each record and it is, the number is different eveytime but the result is still the same. I have also used the strftime() function and that does the same.

Cheers
Marcus

Anon

I tried your code and got the following...

070740 1 19 July

Is there a reason you want the hour echoed twice "Hh"?

Anon

NO, just I wanted to try and example that had been used. I have triued removing it no luck

Thats weird then you get that result. What OS n PHP ver you using?

Anon

I tested it on a WIN NT box running IIS
with PHP 4.04

Just now I ran it on a Linux box running apache with PHP 3 and got the same results

cordex

Can you give us one of your $logtime values as an example to evaluate on our side? that might help narrow the problem down.

-Ben

Anon

Many thanks for lookng into the problem, but I have idscovered my DB eas set up to store the value as TIMESTAMP, changed to integer and all worked fine.

CHeers
Marcus