How to loop through a mysql result set

by

the first example that comes to my mind:

    <?php

    $link = mysql_connect(/*arguments here*/);

    $query = sprintf("select * from table");

    $result = mysql_query($query, $link);

    if ($result) {
      while($row = mysql_fetch_array($result)) {
        // do something with the $row
      }

    }
    else {
      echo mysql_error();
    }
?>

More Related Contents:

  1. Using PHP data in MySQL [closed]
  2. which is better every user have a table or just a row [closed]
  3. I am seeing this error on submitting form Error: query was empty [closed]
  4. PHP – Change value y,n in database [closed]
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. Many-to-many relationships examples
  7. Automated or regular backup of mysql data
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  10. How to upload images into MySQL database using PHP code
  11. PDO mysql: How to know if insert was successful
  12. Maximum execution time in phpMyadmin
  13. How to store file name in database, with other info while uploading image to server using PHP?
  14. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  15. Mechanisms for tracking DB schema changes [closed]
  16. Fetching single row, single column with PDO
  17. Mysql No connection could be made because the target machine actively refused it
  18. Replacing mysql_* functions with PDO and prepared statements
  19. Is there any way to check the performance of mysql Indexing
  20. IP address storing in MySQL database using PHP [duplicate]
  21. phpmyadmin automatic logout time
  22. PHP – Secure member-only pages with a login system
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Fatal error: Call to undefined function mysqli_result()
  25. Laravel nested relationships
  26. Selecting all fields except only one field in mysql [duplicate]
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. MySQL ORDER BY rand(), name ASC
  29. Auto Increment skipping numbers?
  30. How to get last inserted id from table MySQL [duplicate]

Leave a Comment