datetime will not update..

[pneudralics]

lip updates, but not lastlogin. lastlogin is used to record the current datetime. Everytime I hit submit all it gives me are zeros.

 

mysql_query ("UPDATE user SET lip = '$ip', lastlogin = 'NOW()' WHERE id = '$id'");

 

 

[PFMaBiSmAd]

NOW() returns a string and there is no need to put single-quotes around it in the query.

[Mchl]

NOW() returns a string and there is no need to put single-quotes around it in the query.

 

Actually what NOW() returns depends on context.

SELECT NOW(),NOW() + 0;

But 'NOW()' in quotes is just a literal string, the function is not being evaluated.

[pneudralics]

Thanks, just took the quotes out and it's working.