How to loop through a mysql result set

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();
    }
?>

Here is a full example:

http://php.net/manual/en/mysqli-result.fetch-array.php

Connect
Select database
Make query
Cycle on the result and fetch array to get the row

How to loop through a mysql result set

Related

Recent Posts