Fetch into an associative array?

[Anon]

If one uses odbc_fetch_into(), it will return the array, but you can only access the fields through $array[0], $array[2], etc. Is there an ODBC function that will return the array associatively, with the fieldnames? ie, instead of using $array[0], one can use $array["ID"] or something. if I change my queries later, I'll break my code using the $array[0], etc....

Is there a function like this? I have looked through the manual and it doesn't look like it...

--Jason

[Anon]

I don't use ODBC, but it looks like they have a odbc_columns() fuction to extract the column names.

You'll need to figure out how to use that to get the column names, then use compact(). Assuming the results of your DB query are in $ResultsArr

$ColumnNames = odbc_columns($resourceID);

$MyArray = compact($ColumnNames,$ResultsArr);

You should end up with your associative array in $MyArray