Page 1 of 1

Errors when Hosting

Posted: Mon May 10, 2010 4:08 pm
by tito85
Hi,

I uploaded my site to a free hosting and all is working apart for one feature. The feature is to get the rating. Using wamp server locally, everything is working fine. However on the uploaded site it is not...

The error I get is:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/a1024187/public_html/moviedetails.php on line 190

The code in line 190 is:

Code: Select all

echo "<b>" . mysql_result($count, 0, 'ratingsgiven') . "</b> user/s submitted their rating to this movie<hr style=\"border: 1px solid #06C\" />";
Any help Please?

Re: Errors when Hosting

Posted: Mon May 10, 2010 4:25 pm
by flying_circus
tito85 wrote:The error I get is:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/a1024187/public_html/moviedetails.php on line 190
$count is not a valid sql resultset. Something is wrong with the query.

Re: Errors when Hosting

Posted: Mon May 10, 2010 4:29 pm
by mecha_godzilla
Have you checked to see how many rows your query returns? Use mysql_num_rows() to see what values you get - remembering to echo out the mysql_result() first.

HTH,

Mecha Godzilla

Re: Errors when Hosting

Posted: Tue May 11, 2010 8:19 am
by tito85
Hi,

This is the code I am using... I am confused because on the locally wamp server it is working...

Any help please?

Code: Select all

          //Rating
          echo "<div class=\"blog2\"><h4 style=\"margin: 0\">Average User Rating</h4><hr style=\"border: 1px solid #06C\" />";
          $query = "SELECT SUM(Rating)/COUNT(0) AS averagerating FROM ratings r WHERE r.MovieID = '" . $_GET['id'] . "'";
          $averagerating = mysql_query($query);
          $query = "SELECT COUNT(0) AS ratingsgiven FROM Ratings r WHERE r.MovieID = '" . $_GET['id'] . "'";
          $count = mysql_query($query);
          echo "The average user rating of this movie is: <b>";
          if (mysql_result($averagerating, 0, 'averagerating')) {
              echo round(mysql_result($averagerating, 0, 'averagerating'), 1);
          } else
              echo "0";
          echo "/10</b><p />";
          echo "<b>" . mysql_result($count, 0, 'ratingsgiven') . "</b> user/s submitted their rating to this movie<hr style=\"border: 1px solid #06C\" />";
          //Checking if user submitted his rating already
          if (isset($_SESSION['user'])) {
              $query = "SELECT * FROM ratings WHERE UserID = '" . $_SESSION['userinfo']['id'] . "' AND MovieID = '" . $_GET['id'] . "'";
              $result = mysql_query($query);
              if (mysql_num_rows($result) > 0) {
                  echo "You already submitted your rating to this movie<p />";
                  echo "Your Rating is: <b>" . mysql_result($result, 0, 'Rating') . "/10</b>";
              } else {
                  echo "<p /><b>Submit your rating:</b>";
?>

Re: Errors when Hosting

Posted: Tue May 11, 2010 8:45 am
by mikosiko

Code: Select all

$query = "SELECT COUNT(0) AS ratingsgiven FROM Ratings r WHERE r.MovieID = '" . $_GET['id'] . "'";
this query is not returning any rows.... try to write it in this way:

Code: Select all

$query = "SELECT COUNT(0) AS ratingsgiven FROM ratings r WHERE r.MovieID = '" . $_GET['id'] . "'";
and... if you allow me to contribute to your code...
- you can improve it writing both sql sentences in just one like this

Code: Select all

  $query = "SELECT COUNT(0) AS ratingsgiven, ROUND(AVG(rating),1) AS averagerating FROM ratings r WHERE r.MovieID = '" . $_GET['id'] . 
and then display the results

Code: Select all

  $row = mysql_fetch_assoc($query);   // This will replace the 2 mysql_result that you are using
   echo "The average user rating of this movie is: <b>" . $row['averagerating']. "<br />";
   echo "<b>" . $row['ratingsgiven'] . "</b> user/s submitted their rating to this movie<hr style=\"border: 1px solid #06C\" />";

Re: Errors when Hosting

Posted: Tue May 11, 2010 9:08 am
by tito85
Hi there tnx for your help. I did not notice that it was so case sensitive...

However i have encountered another problem in anothor thing...

Parse error: syntax error, unexpected $end in /home/a1024187/public_html/addnews.php on line 12

Cannot understand what is the error too... Hope it is a small mistake like the other one...

Code: Select all

<?php
  session_start();
  require('dbconnect.php');
  include('securitycheck.php');
  if ($isAdmin) {
      if (isset($_POST['btnCancel'])) {
          header('Location: index.php');
      } elseif (isset($_POST['btnAddNews'])) {
          $title = $_POST['txtTitle'];
          $body = $_POST['txtBody'];
          if (strlen(trim($title)) > 0 && strlen(trim($body)) > 0) {
              $insert = "INSERT INTO news (Title, Body, PostDateTime, UserID) VALUES ('" . mysql_real_escape_string($title) . "', '" . mysql_real_escape_string($body) . "', '" . date("Y-m-d H:i:s") . "', '" . $_SESSION['userinfo']['id'] . "')";
              mysql_query($insert) or die(mysql_error());
              header('Location: index.php');
          } else {
              $message = "Error: Both <b>Title</b> and <b>Body</b> are mandatory";
          }
      }
  } else {
      header('Location: index.php');
  }
?>

Re: Errors when Hosting

Posted: Tue May 11, 2010 9:15 am
by mikosiko
check your dbconnect.php and securitycheck.php files for the variable $end

Re: Errors when Hosting

Posted: Tue May 11, 2010 11:38 am
by tito85
I have no variables $end used in the site. I don't know why it is saying this...

Re: Errors when Hosting

Posted: Tue May 11, 2010 2:55 pm
by flying_circus
tito85 wrote:Parse error: syntax error, unexpected $end in /home/a1024187/public_html/addnews.php on line 12
This usually indicates a syntax error, such as a misplaced semicolon or missing closing brackets. Please post all of your code.

Re: Errors when Hosting

Posted: Wed May 12, 2010 5:46 am
by tito85
Hi,

This is all the code of the page.

Thanks for any help!

Code: Select all

<?php
  session_start();
  require('dbconnect.php');
  include('securitycheck.php');
  if ($isAdmin) {
      if (isset($_POST['btnCancel'])) {
          header('Location: index.php');
      } elseif (isset($_POST['btnAddNews'])) {
          $title = $_POST['txtTitle'];
          $body = $_POST['txtBody'];
          if (strlen(trim($title)) > 0 && strlen(trim($body)) > 0) {
              $insert = "INSERT INTO news (Title, Body, PostDateTime, UserID) VALUES ('" . mysql_real_escape_string($title) . "', '" . mysql_real_escape_string($body) . "', '" . date("Y-m-d H:i:s") . "', '" . $_SESSION['userinfo']['id'] . "')";
              mysql_query($insert) or die(mysql_error());
              header('Location: index.php');
          } else {
              $message = "Error: Both <b>Title</b> and <b>Body</b> are mandatory";
          }
      }
  } else {
      header('Location: index.php');
  }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="CSSWebStyles/style.css" />
<title>Add News</title>
</head>
<body>
<div id="website">
<?php
  include('banner.php');
?>
<?php
  //checking if the user is an administrator
  if (isset($_SESSION['superadmin'])) {
      if ($_SESSION['superadmin'])
          include('adminmenu.php');
  }
?>
<div id="content">
<div id="contentleft">
<h2>Add News</h2>
<?php
  if (isset($message)) {
      echo "<center>$message</center>";
      unset($message);
  }
?>
<form method="post">
<table>
<tr>
<td>
Title
</td>
<td>
<input type="text" style="width: 300px;" name="txtTitle" />
</td>
</tr>
<tr>
<td valign="top">
Body
</td>
<td>
<textarea name="txtBody" rows="7" cols="45"></textarea>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="btnAddNews" value="Add" />&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="btnCancel" value="Cancel" />
</td>
</tr>
</table>
</form>
</div>
</div>
<?php
  //will include the code from footer.php file
  include('footer.php');
?>
</div>
</body>
</html>

Re: Errors when Hosting

Posted: Wed May 12, 2010 12:05 pm
by flying_circus
I don't see anything out of the ordinary in this file, but I suspect the culprit might be in one of the includes:
  • dbconnect.php
  • securitycheck.php
  • banner.php
  • adminmenu.php
  • footer.php

Re: Errors when Hosting

Posted: Wed May 12, 2010 12:17 pm
by tito85
What i did is that in the following line...

'" . date("Y-m-d H:i:s") . "'

I changed it to: '" . date('Y-m-d H:i:s') . "'

It seems to be working...

Re: Errors when Hosting

Posted: Wed May 12, 2010 12:23 pm
by flying_circus
Interesting... thanks for posting the solution.