if(isset($_SESSION['username']))
{
   $con = mysql_connect('localhost','root','');
   mysql_select_db('chatbox',$con);

   $result = mysql_query("SELECT id FROM users");
   mysql_query("UPDATE users SET `online` = 0 WHERE `username` = ".$username."");
}


您能否使用户名是会话(已登录)等于

mysql_query("UPDATE users SET `online` = 0 WHERE `username` = "to_put_it_here");

最佳答案

简单可爱的把戏

$username = $_SESSION['username'];
if(isset($username))
{
   $con = mysql_connect('localhost','root','');
   mysql_select_db('chatbox',$con);

   $result = mysql_query("SELECT id FROM users");
   mysql_query("UPDATE users SET `online` = 0 WHERE `username` = '$username' ");
}

07-24 09:37
查看更多