我无法弄清楚如何更新我的上次登录时间

Question

I'm trying to make an last activity function for an website. but i can't get it to work. I hope you guys can help me out here.

this is my query:

$last_activity_query = "UPDATE users_table SET user_name  = '$user_name' WHERE 'date_last_inlog' = NOW()";

$result_update =  mysql_query($last_activity_query);

$last_activity_update = mysql_fetch_array($result_update);

this is an print screen of my database table:

I want to store this update in the last row.

Thanks in advance!

i've changed my script now but its still not changing anything in my database table.

this is the change:

if (isset($_REQUEST['inlog_submit'])){//checks if form is submitted


                    $user_name = $_REQUEST['username_input'];//request username from inlog_form
                    $password = $crypt;//gets enqrypted pass
                    //$tbl_name="user_table"; // Table name
                    $query = "SELECT * FROM users_table WHERE user_name= '$user_name' AND password='$password'";//query stored in var
                    $last_activity_query = "UPDATE users_table SET 'date_last_inlog' = NOW() WHERE user_name  = '$user_name'";
                    $result = mysql_query($query);//var with result of query
                    $result_update =  mysql_query($last_activity_query);

                    if ($user_name = mysql_fetch_array($result)){//checks inlog data from form with the $result query
                        $_SESSION['user_name'] = $user_name[user_name];//creates session with username
                        $_SESSION['password'] = $password[password];//creates session with password
                        $last_activity_update = mysql_fetch_array($result_update);
                        header ('Location: admin.php');//when login is correct redirect to specified page
                    }else{
                        $error_inlog = 10;//when inlog data is incorrect this error will show
                    }
                }
            ?>

Answer 1

Your SQL query is in the wrong order.

$last_activity_query = "UPDATE users_table SET 'date_last_inlog' = NOW() WHERE user_name  = '$user_name'";