Question

我的php档案中有以下查询:

    if ($user) { //user is logged in (which he is)
        $highscore = mysql_query("SELECT highscore FROM highscore WHERE fbID = $user"); //wil give 200
        $fb_country_str = nl;

        if (mysql_num_rows($highscore) == 0) { //if no result from highscore set it to 1
            $highscore = 1;
        } else { //if we do get a result, select the country (in this case it is: uk)
            $country = mysql_query("SELECT country FROM highscore WHERE fbID = $user");
            if (!($country == $fb_country_str)) { //if the country is NOT the same, update the country with $fb_country_str (which in this case it should update)
                $sql = mysql_query("UPDATE highscore SET country = $fb_country_str WHERE fbID = $user");
            }
        }
    }

当运行时, 它不更新数据库, 国家 uk 应该在哪里被更改为 nl 。为什么不呢? 我错过了什么?

谨请注意:

Answer 1

mysql_query 函数不返回字符串, 它会返回一个资源, 您可以用其它的 Mysql 函数使用( 见 < a href=" http://php. net/ mysql_query" rel= "nofolp" > http://php. net/ mysql_query )

所以您变量的“ 强” $ 国家 < / 强” 并不是您所期望的。您需要使用“ 强” Mysql_ fetch_ assoc

您可以在php.net manp 页面上看到样本,您也可以使用返回值作为资源(而不是标量值),当您在 < 强'$highscore 上调 Mysql_ num_ rows 函数时,该脚本中已经使用返回值作为资源( 而不是标量值) 。

Answer 2

   if ($user) { //user is logged in (which he is)
        $highscore = mysql_query("SELECT highscore FROM highscore WHERE fbID = $user"); //wil give 200
        $fb_country_str = "nl"; //It s a string , you need quotes.

        if (mysql_num_rows($highscore) == 0) { //if no result from highscore set it to 1
            $highscore = 1;
        } else { //if we do get a result, select the country (in this case it is: uk)
            $getCountry = mysql_query("SELECT country FROM highscore WHERE fbID = $user");
//NOTICE - COUNTRY IS NOT THE COUNTRY VALUE YET!
$country = mysql_fetch_array($country);
$country = $country[ country ];
            if (!($country == $fb_country_str)) { //if the country is NOT the same, update the country with $fb_country_str (which in this case it should update)
                $sql = mysql_query("UPDATE highscore SET country = $fb_country_str WHERE fbID = $user");
            }
        }
    }

Answer 3

$user - 您在查询中将它作为布尔处理( 如果声明的话), 然后是数字( 如果我假设正确的话) 。

Answer 4

如果条件改变您最后的状态

if ($country != $fb_country_str) 
{ 
//if the country is NOT the same, update the country with $fb_country_str (which in this case it should update)
$sql = mysql_query("UPDATE highscore SET country = $fb_country_str WHERE fbID = $user");
}

友情链接