Date/Time Display Issue

[tomyknoker]

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?

[thetestingsite]

By default, the loginDateTime column (on your set up that is) inserts the datetime as 0000-00-00 00:00:00. This is why it is showing up as zeros. Try changing the data for those users by adding a fake login date to the loginDateTime column and see if that still shows zeros.

Hope this helps.