MySQLi count(*) always returns 1

by

You have to fetch that one record, it will contain the result of Count()

$result = $db->query("SELECT COUNT(*) FROM `table`");
$row = $result->fetch_row();
echo '#: ', $row[0];

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to change mysql to mysqli?
  3. How to prevent duplicate usernames when people register?
  4. Best way to INSERT many values in mysqli?
  5. SELECT COUNT(*) AS count – How to use this count
  6. How to use mysqli prepared statements?
  7. MySQLi prepared statements error reporting [duplicate]
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. How to call a MySQL stored procedure from within PHP code?
  12. Do I have to guard against SQL injection if I used a dropdown?
  13. Using MySQLi from another class in PHP
  14. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  15. Call to a member function execute() on boolean in [duplicate]
  16. Mysql No connection could be made because the target machine actively refused it
  17. How to connect to MySQL database in PHP using mysqli extension?
  18. Unknown database error in PHP but it exists in PHPMyAdmin
  19. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  20. Can I blindly replace all mysql_ functions with mysqli_?
  21. Fatal error: Call to undefined function mysqli_result()
  22. Using PHP to execute multiple MYSQL Queries
  23. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  24. How to run multiple insert query in SQL using PHP in one go?
  25. Strange problem with the length of the field gotten from database [duplicate]
  26. PHP: mysql v mysqli v pdo [closed]
  27. How do I ensure I caught all errors from MySQLi::multi_query?
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. Why cannot the PHP hide the error message thrown by the MySQL connection?

Leave a Comment