无法将两个数组合并为一个来获取sql查询

Question

Its might sounding like a noob question but I can't find an answer. Currently I have this.

$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                $gridData[] = array(
                'CompanyName' => $row['CompanyName'],
                'ContactName' => $row['ContactName'],
                'ContactTitle' => $row['ContactTitle'],
            'Address' => $row['Address'],
            'Country' => $row['Country'],
            'Parent' => $row['Parent'],
            'City' => $row['City'],
            'id' => $row['id']
      );
}

but assuming I don't want to hardcode this fields there I have another array which is stored in $fields and has the structure of an array inside so field [0] is the fieldname.

so I do

 foreach ($fields as $field)
     {
       $gridData[$field[0]] => $row[$field[0]];
     }

by some reason it does not work like this. what is the way to do this properly? How can I bring this together?

Answer 1

$gridData[] = array() 

will add a numerical index to the $gridData array with value of what is in the array. You are trying to do

$gridData[$field[0]] => $row[$field[0]];

which is trying to reference a string index. Try:

foreach ($gridData as $rowIndex => $gridRow){
  foreach ($fields as $field)
  {
    $gridData[$rowIndex][$field[0]] => $row[$field[0]];
  }
}

Alternatively, if you would be ok modifying your field data structure, you could use http://php.net/manual/en/function.array-merge.php