[RESOLVED] create array of array from query

ledtear

How could I create something like:

$data = array(
  array("firstname" => "Mary", "lastname" => "Johnson", "age" => 25),
  array("firstname" => "Amanda", "lastname" => "Miller", "age" => 18),
  array("firstname" => "James", "lastname" => "Brown", "age" => 31),
  array("firstname" => "Patricia", "lastname" => "Williams", "age" => 7),
  array("firstname" => "Michael", "lastname" => "Davis", "age" => 43),
  array("firstname" => "Sarah", "lastname" => "Miller", "age" => 24),
  array("firstname" => "Patrick", "lastname" => "Miller", "age" => 27)
);

from a db query?

leatherback

in its most basic version:

$output = array();
while($row=mysql_fetch_array($resultset))
  {
  $output[] = $row;
  }

ledtear

awesome - definetly sends me on the right path... How could I more customize it? Should I do it through the query (i.e. select field1 as newfieldname....) or can I do that through the loop? something like:
{
$output[] = array("firstname" => "Patrick", "lastname" => "Miller", "age" => 27)
}

ledtear

I am also getting double results... meaning if I say:

select field1 as "Field One" from.....

I am getting the field returned twice... once under the name "0" and once under the name "Field One"....

????

leatherback

yeah, the fetch_array returns values under the colum name, and the colum number.

So better the way you suggested yourself, if you ahve a lot of information passing through..
this should work well:

$output[] = array("firstname" => "Patrick", "lastname" => "Miller", "age" => 27)

$output[] = array(
  "firstname" => $row['firstname'], 
  "lastname" => $row['lastname'], 
  "age" => $row['age']
  );

ledtear

beautiful! thanks....