MySQL不刷新？

Question

    <?php
$result = mysql_query('SELECT Ban FROM players WHERE Name = "'.$user.'" LIMIT 1') or die(mysql_error().":".mysql_errno());
if(mysql_num_rows($result) == 1){
echo 'User is banned';
}else {
echo 'User is not banned';

}
?>

当用户被取消禁止时，网站上仍显示“用户已被禁止”。所以不刷新，但是在mysql中一切正常。有人帮忙吗？

Answer 1

mysql_num_rows 返回获取的行数。您可以通过以下方式解决您的问题:

SELECT id FROM players WHERE Name = "'.$user.'" AND Ban = 1 LIMIT 1