[williamh26]

I have this code: to add a comments

PHP Code:

<?php

     $prodid = $_GET['id'];

  mysql_connect($host,$user,$password); // connect to mysql server //
mysql_select_db($db);

 $query = "SELECT count(commentid) from comments where prodid = $prodid";
$result = mysql_query($query);
$row=mysql_fetch_array($result);
if ($row[0] == 0)
{
   echo "Add your comments about this Drug. \n";
   echo"<p>\n";
   echo "No comments posted yet.  \n";
   echo "<a href=\"index.php?content=newcomment&id=$prodid\">Add a comment</a>\n";
   echo "   <a href=\"print.php?id=$prodid\" target=\"_blank\">Print Details</a>\n";
   echo "<hr>\n";
} else
{
   $totrecords = $row[0];
   echo $row[0] . "\n";
   echo " comments posted.  \n";
   echo "<a href=\"index.php?content=newcomment&id=$prodid\">Add a comment</a>\n";
   echo "   <a href=\"print.php?id=$prodid\" target=\"_blank\">Print Details</a>\n";
   echo "<hr>\n";
   echo "<h6>Comments:</h6>\n";

   if (!isset($_GET['page']))
      $thispage = 1;
   else
      $thispage = $_GET['page'];

   $recordsperpage = 2;
   $offset = ($thispage - 1) * $recordsperpage;
   $totpages = ceil($totrecords / $recordsperpage);

   $query = "SELECT date,poster,comment from comments where prodid = $prodid order by commentid desc limit $offset,$recordsperpage";
   $result = mysql_query($query) or die('Could not retrieve comments: ' . mysql_error());
   while($row = mysql_fetch_array($result, MYSQL_ASSOC))
   {
       $date = $row['date'];
       $poster = $row['poster'];
       $comment = $row['comment'];
       $comment = nl2br($comment);

       echo $date . " - posted by " . $poster . "\n";
       echo "<br>\n";
       echo $comment . "\n";
       echo "<br><br>\n";
   }

   if ($thispage > 1)
   {
      $page = $thispage - 1;
      $prevpage = "<a href=\"index.php?content=showprod&id=$prodid&page=$page\">Prev</a>";
   } else
   {
      $prevpage = " ";
   }

   if ($totpages > 1)
   {
      $bar = '';
      for($page = 1; $page <= $totpages; $page++)
      {
         if ($page == $thispage)
         {
            $bar .= " $page ";
         } else
         {
            $bar .= " <a href=\"index.php?content=showprod&id=$prodid&page=$page\">$page</a> ";
         }
      }
   }

   if ($thispage < $totpages)
   {
      $page = $thispage + 1;
      $nextpage = " <a href=\"index.php?content=showprod&id=$prodid&page=$page\">Next</a>";
   } else
   {
      $nextpage = " ";
   }

   echo "GoTo: " . $prevpage . $bar . $nextpage;
}
?>

However i have this error message
Warning: include(showprod.inc.php) [function.include]: failed to open stream: No such file or directory in C:\wamp\www\Rite Aid\index.php on line 198

Warning: include() [function.include]: Failed opening 'showprod.inc.php' for inclusion (include_path='.;C:\php5\pear') in C:\wamp\www\Rite Aid\index.php on line 198


i checked all the files and there are in the correct file can anyone help me please

[Nico]

I didn't count the lines, but I think it's save to say that your code does not have 198. Meaning, the code you posted has nothing to do with the error you posted.

[williamh26]

i fixed the script