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?!

[l_kris06]

Hi,

Notice that ,

array_push($LOGIN_INFORMATION, $row); 

$row will only contain array info and not the value itself.

Heres the code that will help u. I have tested it locally and it works.

<?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)) {
    array_push($LOGIN_INFORMATION, $row['admin_name']);
}

$totItems = count($LOGIN_INFORMATION); //Contains the total items contained within the array, UPPER BOUND
$i = 0; //LOWER BOUND


while($i<=$totItems){                                      //Iteration through array, you can also use print_r for raw.
echo $LOGIN_INFORMATION[$i]."<BR>";
$i++;
}

?>

[Twey]

Well, admin_name is a column, not a row. If you want to store only that field for each row, then you have to say so:

<?php

  mysql_connect($hostname,$user,$pass)
    or die('Connection error.');
  mysql_select_db('info_moosehead')
    or die('Database selection error.');
  $result = mysql_query('SELECT admin_name FROM Portal_administrators')
    or die('Query error:' . mysql_error());

  $admins = array();

  while ($row = mysql_fetch_array($result))
    $admins[] = $row['admin_name'];

  print_r($admins);

?>

The extra wrapping array comes from the fact that you add the whole array instead of just the appropriate value from it; the duplication of data with both numerical and string keys is what mysql_fetch_array() does by default. You can override it by passing MYSQL_NUM or MYSQL_ASSOC as the second argument.

Edit:

$totItems = count($LOGIN_INFORMATION); //Contains the total items contained within the array, UPPER BOUND
$i = 0; //LOWER BOUND


while($i<=$totItems){                                      //Iteration through array, you can also use print_r for raw.
echo $LOGIN_INFORMATION[$i]."<BR>";
$i++;
}

In other words:

echo implode('<BR>', $LOGIN_INFORMATION) . '<BR>';

... but I'm beginning to suspect that $LOGIN_INFORMATION is an inaccurate identifier, in a couple of ways (all-capitals are generally reserved for constants).