SELECT * FROM... with PHP5 and Access

[8ginga8]

Hello,

I'm trying to SELECT * FROM my_table with PHP5 and an ODBC connection to Ms Access... all my rows are returned but when i try to output something like

echo $row['my_field'];

it doesn't work.

However if I SELECT my_field FROM my_table and then

echo $row['my_field'];

it all works fine.

Do i have to do something special to be able to select * from a DB with Access? I'm used to using PHP/MySQL and this works fine.

Any suggestions?

Thanks,