Is it advisable to try to retrieve the total number of records in a database using mysql_num_rows() when a LIMIT clause is present in the query?

When a LIMIT clause is present in a query, using mysql_num_rows() to retrieve the total number of records in the database is not advisable as it will only return the number of rows fetched by the query, not the total number of rows that match the query criteria. To get the total number of records, you can modify the query to use COUNT() function without the LIMIT clause. 

// Connect to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Query to get total number of records
$query = "SELECT COUNT(*) as total FROM table WHERE condition";

$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);

$totalRecords = $row['total'];

echo "Total number of records: " . $totalRecords;

// Close the connection
mysqli_close($connection);

Keywords

PHP mysql_num_rows() LIMIT clause database retrieval

Related Questions