single row into php variable -possible?

user5716448

Hi,

using php + oracle and can use oci to get multiple rows and format in table.

However if have a sql whcih is using max() and will only ever return one row in thsi case, what is best way to set theresults into a php variable.

Thanks

Christopher Jones-Oracle

I'd use whatever you are most comfortable to use, oci_fetch_array or oci_fetch_all.  If you really worry about performance, then try some benchmarks.  However tuning the SQL and other optimizations (e.g. avoiding round trips) will be more important to address.

user5716448

Thanks for advice - do you have an example - tried searching internet and each one tends to have while loop

Christopher Jones-Oracle

Just remove the loop?

user5716448

Thanks for reply.