mysqli_num_rows() problem
Posted: Fri Feb 04, 2011 2:20 pm
Hey guys,
here's the script:
The error turns out to be Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\Book\index.php on line 22
why is that?
here's the script:
Code: Select all
<?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 = mysqli_query($db, $sql);
$row = mysqli_fetch_assoc($result);
echo "<p><h2><a href='viewentry.php?id=".$row['id']."'>'".$row['subject']."</a></h2><br /></p>";
echo "<p>"."<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></p>";
echo "<p>";
echo nl2br($row['body']);
echo "</p>";
echo "<p>";
$commsql = "SELECT name FROM comments WEHRE blog_id = " .$row['id']."ORDER BY dateposted;";
$commresult = mysqli_query($db, $commsql);
$numrows_comm = mysqli_num_rows($commresult);
if($numrows_comm == 0){
echo "<p>No comments.</p>";
} else {
echo "(<b>".$numrows_com."</b>)comments: ";
$i = 1;
while($commrow = mysqli_fetch_assoc($commresult)){
echo "<a href='viewentry.php?id=".$row['id']."#comment".$i."'>'".$commrow['name']."</a>";
$i++;
}
}
echo "</p>";
require("footer.php");
?>
The error turns out to be Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\Book\index.php on line 22
why is that?