In my login file I have this code to add an entry to my login table.When it is run and I see what the date/time was in the database I get:PHP Code:// Create an entry to the login table...
$query = "INSERT INTO `login` (`user_id`, `staff`, `guid`, `lastactive`) ";
$query.= "VALUES (".$UserID.", 'no', '".$UserGUID."', '".date("Y-m-d H:i:s" ,time())."')";
$results = mysql_query($query);
2000-11-00 44:68:93
So I then Added in theses lines just after the above:The output and data in database was:PHP Code:$Date = date("Y-m-d H:i:s" ,time());
echo "date(\"Y-m-d H:i:s\" ,time()) = $Date";
2004-11-14 07:41:41
So I then removed these two debug lines and the next time the entry to the database was:
2000-11-00 44:70:74
I can't understand how those two lines could possibly affect the SQL that is done before it.
Update: I have tested this a few times since posting this and its the echo statement, if I take it out its the wrong time if I put it in its the right time, but I get errors later on cos I still have header info to send.




.
)
Reply With Quote