mysqli_num_rows() error

[mlummus]

Getting the error: "Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean" and haven't been able to spot where its coming from. Any insight out there?

 

$db = mysqli_connect("dbserver.com", "user", "password");
if (!db) {echo "Error: Could not connect to database."; 
exit;}
mysqli_select_db($db, "dbname");

$query = "SELECT id FROM student";
$result = mysqli_query($db, $query);
$num_results = mysqli_num_rows($result);

[tartou2]

i guess it is mysql and not mysqli

[PFMaBiSmAd]

The error means that your query failed due to an error and returned a FALSE value instead of a mysqli_result.

 

For debugging purposes (remove it after you are done), echo mysqli_error($db); on the next line after the mysqli_query() line to find out why the query failed.