please help me
when i run my code
by using Mysql_num_rows()
Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\php\connect to database.php on line 13

this is my code

/* declar some relevant variables */
$Host = "localhost"; //location of mySQL on server
$Table = "books"; //name of the table within the database

     mysql_connect ($Host,$Table) or
     die ("unable to connect to database");
     //mysql_select_db("$Name") or
     //die ("unable to select DB");
     $sqlquery = "SELECT * FROM $Table";
     $result = Mysql_query($sqlquery);
     $number = Mysql_num_rows($result); 


what shall i do


Edited by Dani: Formatting fixed

11 Years
Discussion Span
Last Post by Zachery
$host = "localhost";
$user = "me"
$pass = "super-secret";
$database = "db";
$table = "books";

//you need to put them in this order, the table name does not go here!
$db = mysql_connect ($host, $user, $pass) or die ('I cannot connect to the database because: ' . mysql_error());

//you must select a db, as all tables are in a database

$sql_query = "SELECT * FROM $Table";
$result = mysql_query($sql_query);
if ($result == 0)
     echo "I had a problem running the query!";
     $number = 0;
     echo "my sql query ran sucsessfully";
     $number = mysql_num_rows($result);

you'll notice i put the mysql error number in case there was an error opening the database, I also checked to make sure usign the if statement, add all this extra junk to see where you are going wrong, and then once you figure it out then just clean it up a bit


As paradox has shown with his example, you left out the database, varible so mysql won't know what database it needs to get its data from.

This article has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.