如何在PHP中将所有ODBC结果保存到数组？

Question

I can't seem to find a way to save all rows from odbc_exec to an array. I found php_fetch_array, but that only fetches one row at a time, requiring me to iterate through all rows to put it into an array. Is there a more concise way to do this?

Tried

`
$myArray = array();
while (odbc_fetch_row($result)) { 
  $myArray[odbc_result($result,1)] = odbc_result($result,2); 
}`

and also

 `
$myArray = array();
while ($myRow = odbc_fetch_row($result)) { 
$myArray[$myRow['id']] = $myRow['name']; 
}`

but $myArray is still empty.