mysql_fetch_array return only one row

by

That’s because the array represents a single row in the returned result set. You need to execute the mysql_fetch_array() function again to get the next record. Example:

while($data = mysql_fetch_array($array)) {
  //will output all data on each loop.
  var_dump($data);
}

More Related Contents:

  1. PDO::fetchAll vs. PDO::fetch in a loop
  2. Trying to get property of non-object in [duplicate]
  3. How to select multiple rows from mysql with one query and use them in php
  4. PDO prepared statement fetch() returning double results
  5. How to avoid to display this error in PHP?
  6. Disappears \ from db value [closed]
  7. What to put in database columns when creating registration/login system? (xampp)
  8. How to properly set up a PDO connection
  9. Query with multiple values in a column
  10. Preserve Line Breaks From TextArea
  11. Search with comma-separated value mysql
  12. How to do this in Laravel, subquery where in
  13. How can I loop through a MySQL result set more than once using the mysql_* functions?
  14. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  15. WAMP Cannot access on local network 403 Forbidden
  16. How do I give each registered user their own url using PHP?
  17. PHP inserting multiple checkbox AND textbox arrays into MySQL Database
  18. How do I loop through a MySQL query via PDO in PHP?
  19. How to solve time out in phpmyadmin?
  20. display data from SQL database into php/ html table [closed]
  21. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  22. Getting time difference between two times in PHP [duplicate]
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Is there a way to show a WHERE clause just for one field in MySQL?
  25. MySQL Stored Procedure vs. complex query
  26. Finding free blocks of time in mysql and php?
  27. How to backup MySQL database in PHP?
  28. Convert Time String to Decimal Hours PHP [closed]
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment