我的PHP 5有问题,我会为我的表的最后一个结果做一段时间,如下所示:
while($news = mysql_fetch_assoc("SELECT * FROM acts ORDER BY id DESC LIMIT 0,5"))
但我收到以下信息
警告:mysql_fetch_assoc()期望参数1是资源,中给定的字符串
这是因为您使用错误,不应该将查询传递给mysql_fetch_assoc
函数,而是:
$sql = "SELECT * FROM acts ORDER BY id DESC LIMIT 0,5";
$result = mysql_query($sql,$con);
while($news = mysql_fetch_assoc($result))
{
// do something
}
应该将结果集传递给mysql_fetch_assoc(),而不是查询。
while($news = mysql_fetch_assoc(mysql_query("SELECT * FROM acts ORDER BY id DESC LIMIT 0,5",$con)));