错误截图
报错源代码
<?php
require("header.php");
$sql = "SELECT entries.*, catetogries.cat FROM entries, catetogries
WHERE entries.cat_id = catetogries.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>";
require("footer.php");
?>
指mysql_fetch_assoc()需要一个参数句柄作为源,但是这个传进来的是一个布尔值,即没读取到数据
即:
sql语句出错!!!
查询了下sql数据库,发现数据表名字是catetories,而并非catetogries,修改后即可读取数据