Storing data from SQL in array

Question

I am trying to store the data from my sql database into an array. Currently I have this:

$query = mysql_query("SELECT * FROM  `InspEmail` WHERE  `Company` LIKE  '$company'");

while($row = mysql_fetch_array($query))
    {

        $inspector = $row['name'];

    }

The problem is that I have 8 rows of data. I need to store each 8 names from that database into an array. When I try this:

$inspector = array($row['name']);

It doesn't work.

Answer 1

If you want to store all of the names in an array, you need to define the array outside the scope of the while loop and append to it. Like this:

$nameArray = array();
while($row = mysql_fetch_array($query)) {
    // Append to the array
    $nameArray[] = $row['name'];   
}