Hello,
I have some issues while using php with an Oracle database doing multiple table querys. I am querying 5 tables per statment, and everything works fine. My problem is with using OCIDefineByName(). 2 of the tables have 1 like column. So of course when I use OCIDefineByName() It uses the 2nd value. How can I be more specific with OCIDefineByName() or is there a better way?
Thanks in advance, PyroX
just alias the field in your SQL statement.
select table1.field as newname,table2.field from table1,table2 etc.
then you can access the one field by the name 'newname' and still access the other field by the name 'field'
