remove duplicating fields in php-mysql result rows

Question

After I executed a query and loop through the result to compose an array of records, when I var_dump that array, I see the following:

array
  0 => 
    array
      0 => string '1'
      'id' => string '1'
      1 => string 'record one'
      'name' => string 'record one'
  1 => 
    array
      0 => string '2'
      'id' => string '2'
      1 => string 'record two'
      'name' => string 'record two'

what should I do to turn the above into the following?

array
  0 => 
    array
      'id' => string '1'
      'name' => string 'record one'
  1 => 
    array
      'id' => string '2'
      'name' => string 'record two'

Answer 1

Don't use mysql_fetch_array(). Use mysql_fetch_assoc(). (Or the Mysqli equivalents)