mysqli_fetch_array returning only one result

by

mysqli_fetch_array works by pointers each time it’s called

Imagine the following

$result = mysqli_query($connection, "select university from universities_alpha");
$row = mysqli_fetch_array($result); // this is the first row
$row = mysqli_fetch_array($result); // now it's the second row
$row = mysqli_fetch_array($result); // third row

To actually display the data the way you want it to, I suggest you do the following

$rows = array();
$result = mysqli_query($connection, "select university from universities_alpha");
while($row = mysqli_fetch_array($result)) {
    $rows[] = $row;
}

print_r($rows);

More Related Contents:

  1. Commands out of sync; you can’t run this command now
  2. Object of class mysqli_result could not be converted to string
  3. mysqli_query() expects at least 2 parameters, 1 given
  4. SELECT COUNT(*) AS count – How to use this count
  5. Mysqli update throwing Call to a member function bind_param() error [duplicate]
  6. mysqli bind_param() expected to be a reference, value given
  7. Should I manually check for errors when calling “mysqli_stmt_prepare”?
  8. Why does mysqli num_rows always return 0?
  9. mysqli_real_escape_string() expects exactly 2 parameters, 1 given
  10. INSERT – Number of bind variables doesn’t match number of fields in prepared statement
  11. Call to a member function execute() on boolean in [duplicate]
  12. Mysql No connection could be made because the target machine actively refused it
  13. SSL operation failed with code 1: dh key too small
  14. Can’t pass mysqli connection in session in php
  15. PHP Fatal error: Call to undefined function mysqli_stmt_get_result()
  16. how to bind multiple parameters to MySQLi query [closed]
  17. mysqli ignoring the first row in a table
  18. Returning Multiple Rows with MySqli and Arrays
  19. How to connect to MySQL database in PHP using mysqli extension?
  20. mySQLi prepared statement unable to get_result()
  21. mysqli_select_db() expects parameter 1 to be mysqli, string given
  22. What does the mysqli_error() expects parameter 1 to be mysqli, null given mean?
  23. Mysqli prepared statement column with variable [duplicate]
  24. Using PHP to execute multiple MYSQL Queries
  25. Mysqli prepared statements build INSERT query dynamically from array
  26. Call to undefined function mysqli_result::num_rows()
  27. How to remove the fatal error when fetching an assoc array
  28. Is using prepared statements necessary? [duplicate]
  29. How to run multiple insert query in SQL using PHP in one go?
  30. Strange problem with the length of the field gotten from database [duplicate]

Leave a Comment