表users有三列:id, name, pass。我需要一个简单的left join来获取用户名和他的密码(1),最后一个登录日期时间(成功与否) (2),以及自他上次成功登录(3)以来对特定用户的登录计数。SELECT name, pass, MAX(date)LEFT JOIN logins ON logins.id = users.id
-- here either "GROUP BY users.id" o
= 0
$set_failed_login_attempts=mysql_query("UPDATE login SET failed_login_attempts=0 WHERE= mysql_query("SELECT failed_login_attempts, last_failed_login FROM login WHERE LoginID =