php - mysql_fetch_assoc() 报错

Question

这是我在 php 中的查询代码:

$query3 = mysql_query("SELECT * FROM area_of_work") or die('Invalid query:'. mysql_error());

while($query3 = mysql_fetch_assoc($query3)){
    $flag = true;
    foreach($listOfUserAreas as $obj){
        if($obj->areaId == $query3['id']){
            $flag = false;
            break;
        }  
    }
    if($flag){
        $areaObj = new AreaInfo();
        $areaObj->areaId = $query3['id'];
        $areaObj->areaName = $query3['areaOfWork'];
        $areaObj->areaTableName = $query3['tableName'];
        array_push($listOfUnusedAreas, $areaObj);
    }
}

我收到这个错误:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, array given in C:\xampp\htdocs\job-skills\php\functions\user_unused_area_list.php on line 30 []

看不出有什么不对。谢谢

Answer 1

不要使用相同的变量.. 像这样尝试

$query3 = mysql_query("SELECT * FROM area_of_work") or die('Invalid query:'. mysql_error());

while($result = mysql_fetch_assoc($query3)){
.....//Your code
}