datetime not reflecting current time

[DaveC426913]

All my users have records showing up as the same date-time.

$dt = date("Y-m-d")." ".date("H:m:s");
$sql = "INSERT INTO AuraUsers (`UserName`,`Password`,`StartTime`) VALUES('".$Name."','".$Password."','".$dt."')";

Is thisd completely wrong?

 

[imryn]

Dave,
instead of your .$dt just insert NOW() without quotes and that should fix it for you.

imryn

 

[DaveC426913]

Thanks.

Incidentally, I found the problem in the above:

date("H:m:s") will return 'hour, MONTH, seconds'. To display minutes I needed to use 'i' not 'm'

So, what I was seeing was:
22:04:47
22:04:13
22:04:33
etc.

The hour and seconds were being reported accurately, but the middle value was actually months instead of minutes.