Question

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

<?php
require("header.php");
$sql = "SELECT entries.*, categories.cat FROM entries,categories
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>";
哪错啊
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in F:\serv\DedeAMPZ\WebRoot\Default\index.php on line 8

Answer 1

应该是 header.php 未有成功连结 database ，所以存取内容时就有错误
或是 SQL :
SELECT entries.*, categories.cat FROM entries,categories
WHERE entries.cat_id=categories.id
ORDER BY dateposted DESC
LIMIT 1 有错误

追问

连接没问题 语句也没错误啊 我仔细看了下数据库

追答

可否列出你的database 結構?

Answer 2

可能是没有建立数据库连接而导致查询失败，或者可能是查询语句有误导致查询失败吧。
你可以在
$result=mysql_query($sql);
$row=mysql_fetch_assoc($result);
这两句的中间判断一下查询是否成功，估计应该是查询失败了。