php取消mysql警告,php警告mysql_fetch_assoc

通常,mysql_ *函数使用如下：

$id = 1234;

$query = 'SELECT name, genre FROM sometable WHERE id=' . $id;

// $query is a string with the MySQL query

$resource = mysql_query($query);

// $resource is a *MySQL result resource* - a mere link to the result set

while ($row = mysql_fetch_assoc($resource)) {

// $row is an associative array from the result set

print_r($row);

// do something with $row

}

如果您将某些内容传递给不是MySQL结果资源的mysql_fetch_assoc(无论是字符串,对象还是布尔值),该函数会抱怨它不知道如何处理该参数;这正是你所看到的.

常见问题：如果您将某些内容(有效查询字符串除外)传递给mysql_query,则会收到此警告：

$id = null;

$query = 'SELECT name, genre FROM sometable WHERE id=' . $id;

$res = mysql_query($query);

// $res === FALSE because the query was invalid

// ( "SELECT name, genre FROM sometable WHERE id=" is not a valid query )

mysql_fetch_assoc($res);

// Warning: don't know what to do with FALSE, as it's not a MySQL result resource