您當(dāng)前位置：首頁(yè) > php開源 > php教程 > Warning: mysql_fetch_assoc() expects parameter 1 to be resource

Warning: mysql_fetch_assoc() expects parameter 1 to be resource

來源：程序員人生發(fā)布時(shí)間：2014-05-29 20:53:30 閱讀次數(shù)：3569次

今天學(xué)習(xí)php的時(shí)候遇到了這個(gè)錯(cuò)誤：Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:xampphtdocsmyblogindex.php on line 15

源代碼是:

<?php
$sql="select entries.*,categories.cat from entries,categorie where entries.cat_id=categories.id order by dateposted desc limit 1;";
$result=mysql_query($sql);
$row=mysql_fetch_assoc($result);
echo "<h2><a href='viewentry.php?id=" . $row['id'] . "'>" . $row['subject'] . "</a></h2><br/>";
echo "<i> in <a href='viewcat.php?id=" . $row['cat_id'] . "'>" . $row['cat'] . "</a> - Posted on " . date("D js F Y g.iA",strtotime($row['dateposted'])) . "</i>";
echo "<p>";
echo nl2br($row['body']);
echo "</p>";

百度了一下，找到了解決辦法！他出錯(cuò)的原因是因?yàn)閿?shù)據(jù)庫(kù)中沒有數(shù)據(jù)導(dǎo)致musql_fetch_assoc()函數(shù)返回值為false，所以下面的$row['']使用就出錯(cuò)了,所以在使用mysql_fetch_assoc() 函數(shù)的時(shí)候先對(duì)$result做判斷!

<?php
$sql="select entries.*,categories.cat from entries,categorie where entries.cat_id=categories.id order by dateposted desc limit 1;";
$result=mysql_query($sql);
if($result){
$row=mysql_fetch_assoc($result);
echo "<h2><a href='viewentry.php?id=" . $row['id'] . "'>" . $row['subject'] . "</a></h2><br/>";
echo "<i> in <a href='viewcat.php?id=" . $row['cat_id'] . "'>" . $row['cat'] . "</a> - Posted on " . date("D js F Y g.iA",strtotime($row['dateposted'])) . "</i>";
echo "<p>";
echo nl2br($row['body']);
echo "</p>";
}
else{
echo "沒有文章";
}
?>