How to loop through a mysql result set


What are some different ways to loop through a mysql result set? I'm new to PHP and MySQL so I'm looking for simple ways to loop through and an explanation as to how the provided code works.

11/18/2009 3:26:46 PM

Accepted Answer

Here is a full example:

  1. Connect
  2. Select database
  3. Make query
  4. Cycle on the result and fetch array to get the row
11/25/2016 7:30:21 PM

the first example that comes to my mind:


    $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();

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow