php - PHP中的MySQL查询错误

我的查询无法正常工作。

需要将等级设置为2的那个起作用，但是需要将VIP设置为1的那个不起作用。

我刚得到一张白纸。

问题是什么？

<?php
session_start();
include ("includes/config.php");

$lid = $_SESSION['lid'];

$uQuery = mysql_query("SELECT * FROM users WHERE id = '".$lid."'");
while($uFetch = mysql_fetch_array($uQuery)){
        $uuser = $uFetch['username'];
        $umotto = $uFetch['motto'];
        $ucredits = $uFetch['credits'];
        $upixels = $uFetch['activity_points'];
        $ubelcr = $uFetch['belcredits'];
        $urank = $uFetch['rank'];
        $ufigure = $uFetch['look'];
}

if($urank < '2'){
mysql_query("UPDATE users SET rank = 2 WHERE id = '".$lid."'");
mysql_query("UPDATE users SET vip = 1 WHERE id = '".$lid."'");
}



Header("vip.php?succes=1");
?>

最佳答案

mysql_query("UPDATE users SET rank = 2,vip = '1' WHERE id = '".$lid."'");

关于php - PHP中的MySQL查询错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/16260696/