check if the query returns zero rows [duplicate]

by

You can use the num_rows on the dataset to check the number of rows returned. Example:

$results = $mysqli->query("SELECT ANNOUNCE_NUMBER,ANNOUNCEMENTS,ANNOUNCE_TYPE,POST_DATE FROM home ORDER BY ANNOUNCE_NUMBER DESC");

if ($results->num_rows === 0) {
    echo 'No results';
} else {
    while ($obj = $results->fetch_object()) {
        //output results from database
    }
}

More Related Contents:

  1. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  2. Can I mix MySQL APIs in PHP?
  3. How to change mysql to mysqli?
  4. Best way to INSERT many values in mysqli?
  5. Call to a member function bind_param() on a non-object [duplicate]
  6. How to use mysqli prepared statements?
  7. MySQLi prepared statements error reporting [duplicate]
  8. How can I get an unknown username given an ID?
  9. mysqli last insert id
  10. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  11. mysqli_query() expects parameter 1 to be mysqli, object given
  12. MySQLi count(*) always returns 1
  13. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  14. Use one bind_param() with variable number of input vars
  15. Using Mysqli bind_param with date and time columns?
  16. PHP UPDATE prepared statement
  17. Using MySQLi from another class in PHP
  18. SELECT * FROM in MySQLi
  19. MySQLI binding params using call_user_func_array
  20. Mysqli fetch_assoc vs fetch_array
  21. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  22. Is mysqli extension enabled in this php configuration?
  23. php warning: mysqli_close() expects parameter 1 to be mysqli
  24. Getting error mysqli::real_connect(): (HY000/2002): No such file or directory when I try to access my project on live server [duplicate]
  25. Get number of rows matched by UPDATE query with PHP mysqli
  26. How to use mysqli_query() in PHP?
  27. mysqli_fetch_array returning only one result
  28. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  29. MySqli Commands out of sync; you can’t run this command now [duplicate]
  30. How to insert into MySQL using mysqli

Leave a Comment