| PHP Tablename Issue [message #218566] |
Thu, 08 February 2007 13:06  |
gvandekrol
Messages: 8
Registered: February 2007
|
Junior Member |
|
|
Good Afternoon,
I'm trying to select records from a table using PHP with Oracle.
I had no problems until I tried to select records from the table 'ORDER'
since there is a SQL command called ORDER it conflicts with the tablename.
$s = OCIParse($c, "SELECT * FROM ORDER");
OCIExecute($s, OCI_DEFAULT);
It gives me the errors: invalid table name
When I select records from another table called ORDER_ITEM it works fine.
Changing the table name is not an option.
And when I put single quotes around the table name it still fails.
Any help would be very much appreciated.
[Updated on: Thu, 08 February 2007 13:09] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
