将数据库结果作为数组返回

Question

I have the following code:

$a=array(
    'last' => array('Ford', 'Smith', 'Jones', 'Thomas'),
    'first' => array('Joe', 'Kyle', 'Nick'),
    );

I have all these names in my database, and a couple more like age, etc.

How can I pull all the records from the database and set them as a array for $a? I need them to be in the format above

Answer 1

Did you try this:

$query = "SELECT last, first from names"; //whatever the query is...
$results = mysql_query($query);
$all = array();
while($row = mysql_fetch_array($results)){
   foreach($row as $key=>$value){
       if(!isset($all[$key])) $all[$key] = array();
       $all[$key][] = $value;
   }
}

The results would look something like:

$all=array(
    'last' => array('Ford', 'Smith', 'Jones', 'Thomas'),
    'first' => array('Joe', 'Kyle', 'Nick','Allen'),
...
    );