Populate PHP Array from While Loop

Question

If I am fetching data from a MySQL database and using a while loop to iterate through the data how would I add each one to array?

$result = mysql_query("SELECT * FROM `Departments`"); while($row = mysql_fetch_assoc($result)) {  } 

Answer 1

Build an array up as you iterate with the while loop.

$result = mysql_query("SELECT * FROM `Departments`"); $results = array(); while($row = mysql_fetch_assoc($result)) {    $results[] = $row; } 

Alternatively, if you used PDO, you could do this automatically.

Answer 2

This will do the trick:

$rows = array(); $result = mysql_query("SELECT * FROM `Departments`"); while($row = mysql_fetch_assoc($result)) {   $rows[] = $row; }