In your query here:
UPDATE users_table SET 'date_last_inlog' = NOW() WHERE user_name="$user_name"
Try removing the quotes around date_last_inlog
or changing them to backticks:
UPDATE users_table SET date_last_inlog = NOW() WHERE user_name="$user_name"
Also, don’t use the mysql_*
functions, use mysqli
or PDO
instead. Your code is vulnerable to SQL Injection.
9
solved I can’t seem figure out how to update my last inlog time [duplicate]