Php array with MySQL

[The Midnighter]

I'm trying to create a Php array from a MySQL Table.

Here's what I've got:

 

$LOGIN_INFORMATION = array();

$result = mysql_connect($hostname,$user,$pass);
mysql_select_db('info_moosehead');

$query = "SELECT admin_name FROM Portal_administrators";
$result = mysql_query($query);

if( !$result) {
echo mysql_error() . ": " . mysql_errno();
}

while ( $row = mysql_fetch_array($result)) {
echo $row;
array_push($LOGIN_INFORMATION, $row);
print_r($LOGIN_INFORMATION);
echo "<br>";
}

 

I'm noticing results like this:

 

ArrayArray ( [0] => Array ( [0] => Airfire [admin_name] => Airfire ) )
ArrayArray ( [0] => Array ( [0] => Airfire [admin_name] => Airfire ) [1] => Array ( [0] => JAUGER [admin_name] => JAUGER ) )
ArrayArray ( [0] => Array ( [0] => Airfire [admin_name] => Airfire ) [1] => Array ( [0] => JAUGER [admin_name] => JAUGER ) [2] => Array ( [0] => JBARR [admin_name] => JBARR ) ) 

 

Which isn't what I expected at all, I'm looking for just the row "admin_name" to be pushed into this array, and yet that's what's going into the array.. Why?!

[flyhoney]

<?php
$LOGIN_INFORMATION = array();

$result = mysql_connect($hostname,$user,$pass);
mysql_select_db('info_moosehead');

$query = "SELECT admin_name FROM Portal_administrators";
$result = mysql_query($query);

if( !$result) {
echo mysql_error() . ": " . mysql_errno();
}

while ($row = mysql_fetch_array($result)) {
$LOGIN_INFORMATION[] = $row['admin_name'];
}

foreach ($LOGIN_INFORMATION as $foo) {
echo $foo . '<br />';
}
?>

[The Midnighter]

Oh... well, thank you