What is the difference between using count() and mysql_num_rows() to count the number of results in a MySQL query in PHP?

When counting the number of results in a MySQL query in PHP, it is recommended to use the count() function instead of the deprecated mysql_num_rows() function. The count() function is more versatile and can be used with different types of data structures, while mysql_num_rows() is specific to MySQL result sets. Additionally, count() is a built-in PHP function, making it more reliable and future-proof. 

// Using count() function to count the number of results in a MySQL query
$query = "SELECT * FROM table_name";
$result = mysqli_query($connection, $query);
$num_rows = mysqli_num_rows($result);

echo "Number of rows: " . $num_rows;

Keywords

count() mysql_num_rows() MySQL query PHP difference

Related Questions