I've built a login stats page, which I'm sure worked properl before - but doesn't now! The login date in't enterd into the database (and the logout field is set as current_timepstamp on update, so I cn't use that)
The problem is the last line below:
$WA_fieldNamesStr = "MemID|IPaddress|loginDate";
$WA_fieldValuesStr = "".$row_WAATKmembers['MemID'] ."" . "|" .$_SERVER['REMOTE_ADDR'] . "|" . "current_timestamp";
At the moment, it just enters 0000-00-00 00:00:00 into the database - obviously 'current timestamp is incorrect. I've also tried now() with the same result. The MemID and the IP Address are both inserted.
Any help much appreciated.