[PHP] MySQL problem

[Good Fella]

Hello,

I am extremely new to MySQL and have never managed to get working
smoothly with PHP before. I am trying really hard to understand
how to work it, and am almost there.

I have a problem which I do not know how to resolve and was
wondering if anybody could help me. I have no idea what is wrong
with the code and why I am getting the error message;

Warning: Supplied argument is not a valid MySQL result resource in 
C:\apache\htdocs\sams\chapter10\results.php on line 47

I am currently using a book to aid me with MySQL, and this is an
example from the book. It does not seem to work and I have no idea
what I may have done wrong to obtain this warning.

I have changed my login and password to question marks.

<?

  if (!$searchtype || !$searchterm)

  {
     echo "You have not entered search details.  Please go back and try 
again.";

     exit;

  }


  $searchtype = addslashes($searchtype);

  $searchterm = addslashes($searchterm);

  @ $db = mysql_pconnect("mesh", "bookorama", "bookorama123");

  if (!$db)

  {
     echo "Error: Could not connect to database.  Please try again later.";

     exit;

  }

  mysql_select_db("booktest");

  $query = "select * from booktest where ".$searchtype." like 
'%".$searchterm."%'";

  $result = mysql_query($query);

  $num_results = mysql_num_rows($result);

  echo "<p>Number of books found: ".$num_results."</p>";

  for ($i=0; $i <$num_results; $i++)

  {

     $row = mysql_fetch_array($result);

     echo "<p><strong>".($i+1).". Title: ";

     echo stripslashes($row["title"]);

     echo "</strong><br>Author: ";

     echo stripslashes($row["author"]);

     echo "<br>ISBN: ";

     echo stripslashes($row["isbn"]);

     echo "<br>Price: ";

     echo stripslashes($row["price"]);

     echo "</p>";

  }

?>

The problem seems to be around the lines of code;

$result = mysql_query($query);

$num_results = mysql_num_rows($result);

Any assistance is appreciated.

Yours,

GF.

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]