Rank: ? (10)
Member #: 27981

I try to update my users last login date,
but im not able?
Anybody know why?

I run this:

Code:


ofcourse isnt this the whole script, the rest works, but this one dont ;(

Rank: ? (768)
Member #: 11085

I can't see any errors with your script at first glance, though that may simply be because I just awoke. Nonetheless, I must ask if that particular script generates any errors (and before you answer, be sure that errors are turned on in php.ini).

I can, however, see multiple problems with your script. First of all, you are much better off storing the result of the time() function in the database and calling the date(string format [, int timestamp]) function using it later. This allows you to eventually give users the option to set their own format for the date function, as well as their own offset to the time (offset from GMT where they live). Furthermore, if users have passwords, it would be wise to check them as well as the username whenever running any Mysql query which modifies the user table. This may come as a surprise to you, but it is unspeakably easy to modify $_GET variables, simple to modify $_COOKIE variable, and not too hard to modify $_POST variables on the users end, therefore, your current system allows any user to act as any user if so they wish.

Rank: ? (4827)
Member #: 3416

i strongly agree with this statement.