Array help

[scialom]

Hi,

I need some help with creating an array from the DB

I want to have this array:

$tags = array('weddings' => 32, 'birthdays' => 41, 'landscapes' => 62, 'ham' => 51, 'chicken' => 23, 'food' => 91, 'turkey' => 47, 'windows' => 82, 'apple' => 27);

Now I want to create this array dynamically from the my db using while{}
so I have something like that:

      while ($db=>next_record){
            $name    = $db_record['name'];
            $number = $db_record['number'] ;
            $tags = ????

  }

hope it makes sense...
A

[bpat1434]

while($db->next_record) {
    $tags[$db_record['name']] = $db_record['number'];
}