how do i query from database and assign all info to array?

[Vertical3]

Ok, I have this code to query the users from a database.

function get_adminstaff() {
     $sql = "SELECT * FROM " . PREFIX. "users WHERE authlevel != 'user'";
     $result = mysql_query($sql);
     $numrows = mysql_num_rows($result);
     while ($row = mysql_fetch_array($result)) {
          echo "$row[username]";
     }
}

However, I need to get this info into an array like so:

$array = array(array('name'=>'Scott','position'=>'PimpMaster'),
               array('name'=>'Charles','position'=>'Manager'),
               array('name'=>'Vanessa','position'=>'Clerk'));

How can I go about doing that?

[tomhath]

This should do what you asked (check the column name for userposition, I guessed).

     $sql = "SELECT * FROM " . PREFIX. "users WHERE authlevel != 'user'"; 
     $result = mysql_query($sql); 

$array = array ();

while ($row = mysql_fetch_array($result) ) {
  $array[] = array('name'=>$row['username'], 'position'=>$row['userposition'] );
}
echo '<pre>';
print_r($array);
echo '</pre>';

But if you look at the array it creates, it's kind of an odd design (an array of arrays of arrays). This is more efficient, just an array of key/value pairs.

     $sql = "SELECT * FROM " . PREFIX. "users WHERE authlevel != 'user'"; 
     $result = mysql_query($sql); 

$array = array ();

while ($row = mysql_fetch_array($result) ) {
   $array[$row['username']] = $row['userposition'];
}
echo '<pre>';
print_r($array);
echo '</pre>';

Although if you have duplicate usernames the second way won't work right. You'll need an array of arrays:

     $sql = "SELECT * FROM " . PREFIX. "users WHERE authlevel != 'user'"; 
     $result = mysql_query($sql); 

$array = array ();

while ($row = mysql_fetch_array($result) ) {
  $array[] = array($row['username'], $row['userposition'] );
}
echo '<pre>';
print_r($array);
echo '</pre>';