php - 如何修复此错误 "mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in"？

Question

这个问题在这里已经有了答案:




9年前关闭。

Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select

错误...

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/andar/public_html/sistema/admin/cron.php on line 19

$hoje = strtotime(date("d-m-Y"));

    $db = new DBConfig();
    $db -> config();
    $db->conn();
    $query = mysql_query("SELECT * FROM products WHERE auto_pub = ".$hoje) or die(mysql_error());

    while($res = mysql_fetch_assoc($query)) {
        $query = mysql_query("UPDATE products SET publicado = '0' WHERE auto_pub = ".$hoje) or die(mysql_error());
    }

    $db->close();

Answer 1

$query在 while 之前使用在 while 内... 将变量名称更改为 $query2 ， 例如:

$hoje = strtotime(date("d-m-Y"));

$db = new DBConfig();
$db -> config();
$db->conn();
$query = mysql_query("SELECT * FROM products WHERE auto_pub = ".$hoje) or die(mysql_error());

while($res = mysql_fetch_assoc($query)) {
    $query2 = mysql_query("UPDATE products SET publicado = '0' WHERE auto_pub = ".$hoje) or die(mysql_error());
}

$db->close();

希望能帮助到你。