警告:mysql_fetch_array()期望参数1为资源[...] [英] Warning: mysql_fetch_array() expects parameter 1 to be resource [...]

问题描述

可能重复:
PHP:警告:sort()需要参数1成为数组，给定资源

Possible Duplicate:
PHP: Warning: sort() expects parameter 1 to be array, resource given

错误是警告:mysql_fetch_array()期望参数1为资源， 在第39行上给定的布尔值"，第39行是"$ row = mysql_fetch_array($ result);".我吓坏了，这是怎么回事?

The error is "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [...] on line 39", line 39 is "$row = mysql_fetch_array($result);". I'm freaking out, what's wrong with it?

推荐答案

mysql_query失败并在$result中返回FALSE.

您应该检查返回的值:

$id = mysql_real_escape_string($GET["id"]);
if ($result = mysql_query("SELECT * FROM Setting WHERE ID = '$id'"))
    $row = mysql_fetch_array($result);
else
    print htmlencode(mysql_error()) . "\n";

当然，您绝对不应在查询中直接输入$GET["id"]:

And of course you should never put $GET["id"] right into the query:

这篇关于警告:mysql_fetch_array()期望参数1为资源[...]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！