The occurrence of mysql_num_rows is prompting a server-wide malfunction

Question

I am trying to determine if a record exists:

$query = "SELECT * FROM `collegeInfo` WHERE `name` = '$name' ";
$existed = mysqli_query($con, $query);
echo mysql_num_rows($existed);

The third line is causing an error:

500 - Internal server error.
There seems to be an issue with the resource you are seeking and it cannot be displayed.

Any advice? Thank you!

Answer 1

Answer №1

Instead of using `mysql_num_rows(), try using mysqli_num_rows()

Here is the correct syntax:

echo mysqli_num_rows($results);

Answer 2

Instead of using `mysql_num_rows(), try using mysqli_num_rows()

Here is the correct syntax:

echo mysqli_num_rows($results);

Answer 3

To retrieve the number of rows in a MySQLi result set, it is recommended to use the function mysqli_num_rows(). Replace your code with:

echo mysqli_num_rows($result);

Answer 4

To retrieve the number of rows in a MySQLi result set, it is recommended to use the function mysqli_num_rows(). Replace your code with:

echo mysqli_num_rows($result);

Answer 5

It's important to note that using mysql and mysqli together is not recommended, as shown in this example:

 <?php
      echo mysql_num_rows($existed);
 ?>

A better approach would be:

<?php
    echo mysqli_num_rows($existed);
?>

Give it a try and see if it solves the issue.

Answer 6

It's important to note that using mysql and mysqli together is not recommended, as shown in this example:

 <?php
      echo mysql_num_rows($existed);
 ?>

A better approach would be:

<?php
    echo mysqli_num_rows($existed);
?>

Give it a try and see if it solves the issue.