A
Anonymous
Guest
Hi,
I don't understand your query, and the code you posted cannot produce the error you posted. However, it is worth noting that while mysql can use lowercase column names, with oracle you MUST use UPPERCASE to retrieve the column values from the row.
For example:
But once you have the row, you MUST use uppercase.
If this is your first time with oracle and php, I suggest you try a very simple example, and post the results if it fails.
I don't understand your query, and the code you posted cannot produce the error you posted. However, it is worth noting that while mysql can use lowercase column names, with oracle you MUST use UPPERCASE to retrieve the column values from the row.
For example:
Code:
// You can use lowercase for the column in the sql statement:
select 'foo' as city_name from dual;
Code:
print $row['city_name'] // Fails with Notice: Undefined index: city_name in ...
print $row['CITY_NAME'] // Works, outputs 'foo'