Oracle query HELP!

[jamesloi]

Hi,

Does anyone know how to chnage this code so that it uses the ORA functions instead of the OCI...

$s = OCIParse($c, "SELECT * FROM ML_Account WHERE ACCOUNTNUM ='$account'");

OCIExecute($s, OCI_DEFAULT);

while (OCIFetch($s)) {

//Agent Name
echo ". ociresult($s, "NAME") . ";

}

Thanks 😃

[LordShryku]

I'd think the first question would be why? Oracle functions were made previous to the OCI functions, for Oracle 7. Beyond that, do you have the Oracle functions supported in your php build? If you're really wanting to, there's plenty of examples in the manual...