Supplied argument is not a valid MySQL result resource

[gaugeboson]

  I am having some trouble getting this tutorial to work.  Here is the code: 

<?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 j F Y g.iA",
strtotime($row['dateposted'])) . 
  "</i>";
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);
[b]$numrows_comm = mysql_num_rows($commresult);[/b]
if($numrows_comm == 0) {
  echo "<p>No Comments.</p>";
}
else {
  echo "(<strong>" . $numrows_comm . " </strong>) comments : ";
  $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 entrie, 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>No previous entries.</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");

?>

 

EDITED BY WILDTEEN88: Please use code tags (

[/coded]) when posting code.[/b]

[revraz]

First error:

 

$sql = "SELECT entries.*, categories.cat FROM entries, categories

WHERE entries.cat_id = categories.id

ORDER by dateposted DESC

LIMIT 1;";

 

Remove the first ; after Limit 1

[gaugeboson]

It was the spacing between the quote and Order Posted. 

 

"ORDER BY dateposted;";

to

" ORDER BY dateposted;";

 

Incidently, I don't see taking out that semi-colon having any change.