date and time display

[trent]

Hi all,

I log the date and time people log into my site, I was able to display this using this code

<?php echo $qry['loginDateTime']; ?>

, but I wanted to change the way the date and time were displayed so I added this

<?php echo date('d/m/Y H:i:s', strtotime($qry['loginDateTime']));  ?>

, that fixed the issue but now something wierd is happening. Not many members have logged in since I added the loginDateTime column in my db. So with the first code it just displayed nothing for members that haven't logged and that is fine. But with the new code if they haven't logged in it populates the field anyway with today's date and a time of 00:00:00... Any ideas as to why this is happening?

[kev woodman]

Hmm I would have thought you would have had 01/01/1970 01:00:00 because date will return a result even though the parameter you pass to strtotime is empty.

Do you have a default value in the table for new visitors?