Why does my array have an index and a key?

[AZDJedi]

Hi,

I can't seem to figure out, or Google an answer as to why the my code produces the following:

Code: Select all

      $this->db->connect();
      $this->db->query("SELECT Friend FROM `customer-friend` WHERE CustomerID=$customerID");
                     
      $result = array();
      while ( $row = $this->db->nextRecord() ) {
         array_push($result, $row);
      }
      $this->db->disconnect();


The output is as follows

Code: Select all

Array
(
    [0] => Array
        (
            [0] => 1
            [Friend] => 1
        )

    [1] => Array
        (
            [0] => 92
            [Friend] => 92
        )

    [2] => Array
        (
            [0] => 99
            [Friend] => 99
        )
)


My question is why does it duplicate the values for each element?

[simplypixie]

Try changing this

Code: Select all

while ( $row = $this->db->nextRecord() ) {
         array_push($result, $row);
      }

To this

Code: Select all

while ( $row = $this->db->nextRecord() ) {
         $result[] = $row;
      }