执行时出错:
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\index.php on line 10
In - posted on Thu Jst January 1970 12.00AMNo database selected网页源码如下:
<?php
require("header.php");
$db=mysql_connect($dbhost,$dbuser,$dbpassword);
mysql_select_db($dbdatabase,$db);
$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>";
if(isset($_SEESION['USERNAME'])==TRUE){
echo "[<a href='updateentry.php?id=". $row['id']
."'>edit</a>]";
}
echo "<p>";
echo nl2br($row['body']);
echo "</p>";
echo "<p>";
$commsql="SELECT name FROM comments WHERE
blog_id=".$row['id']." ORDER BY dateposted;";
$commresult=mysql_query($commsql);
if(!$commresult){
echo mysql_error();
exit;
}
$numrows_comm=mysql_num_rows($commresult);
if($numrows_comm==0){
echo "<p>没有评论.</p>";
}
else
{
echo "(<strong>".$numrows_comm."</strong>) 评论:";
$i=1;
while($commrow=mysql_fetch_assoc($commresult)){
echo "<a href='viewentry.php?id=".$row
['id']."#comment".$i."'>".$commrow['name']."</a>";
$i++;
}
}
echo "</p>";
$prevsql="SELECT entries.*,categories.cat FROM
entries,categories
WHERE entries.cat_id=categories.id
ORDER BY dateposted DESC
LIMIT 1,5;";
$prevresult=mysql_query($prevsql);
$numrows_prev=mysql_num_rows($prevresult);
if($numrows_prev==0){
echo "<p>无任何记录.</p>";
}
else{
echo "<ul>";
while($prevrow=mysql_fetch_assoc($prevresult)){
echo "<li><a href='viewentry.php?id=".$prevrow
['id']."'>".$prevrow['subject']."</a></li>";
}
}
echo "</ul>";
require("footer.php");
?>
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\index.php on line 10
In - posted on Thu Jst January 1970 12.00AMNo database selected网页源码如下:
<?php
require("header.php");
$db=mysql_connect($dbhost,$dbuser,$dbpassword);
mysql_select_db($dbdatabase,$db);
$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>";
if(isset($_SEESION['USERNAME'])==TRUE){
echo "[<a href='updateentry.php?id=". $row['id']
."'>edit</a>]";
}
echo "<p>";
echo nl2br($row['body']);
echo "</p>";
echo "<p>";
$commsql="SELECT name FROM comments WHERE
blog_id=".$row['id']." ORDER BY dateposted;";
$commresult=mysql_query($commsql);
if(!$commresult){
echo mysql_error();
exit;
}
$numrows_comm=mysql_num_rows($commresult);
if($numrows_comm==0){
echo "<p>没有评论.</p>";
}
else
{
echo "(<strong>".$numrows_comm."</strong>) 评论:";
$i=1;
while($commrow=mysql_fetch_assoc($commresult)){
echo "<a href='viewentry.php?id=".$row
['id']."#comment".$i."'>".$commrow['name']."</a>";
$i++;
}
}
echo "</p>";
$prevsql="SELECT entries.*,categories.cat FROM
entries,categories
WHERE entries.cat_id=categories.id
ORDER BY dateposted DESC
LIMIT 1,5;";
$prevresult=mysql_query($prevsql);
$numrows_prev=mysql_num_rows($prevresult);
if($numrows_prev==0){
echo "<p>无任何记录.</p>";
}
else{
echo "<ul>";
while($prevrow=mysql_fetch_assoc($prevresult)){
echo "<li><a href='viewentry.php?id=".$prevrow
['id']."'>".$prevrow['subject']."</a></li>";
}
}
echo "</ul>";
require("footer.php");
?>
In - posted on Thu Jst January 1970 12.00AMNo database selecte
第一种可能:No database selecte
第二种可能:将你的sql语句打印出来 然后phpmyadmin运行一下
<?php
require("header.php");
$db=mysql_connect($dbhost,$dbuser,$dbpassword);//这部分
mysql_select_db($dbdatabase,$db);
$sql="SELECT entries.*,categories.cat FROM
entries,categories
WHERE entries.cat_id=categories.id
ORDER BY dateposted DESC
LIMIT 1;";
$result=mysql_query($sql);