Problems with table name over odbc connection..

[mwylde]

Hi - i've currently got php scripts accessing my paradox v7 database [via odbc] working nicely. However i've one main problem - one of the tables i want to access is actually called 'order' - i didn't create this table and i can't change the name - however when i try to access the table from my php script i.e. 'select * from order' it craps out with an error 'Syntax error in FROM clause' which is obviously because 'order' is a reserved keyword - i've tried wrapping the order name in quotes [single and double] also ticks ` - however i still get errors and the data is not returned - does anyone know a solution to this? - b.t.w. other queries on the database work fine.

Thanks, Martin.

 

[TonyMcGuire]

Have you tried

select * from "order.db"

(note specifically including the .extension)

??

Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities.