Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1

> Array ( [LOG_ID] => 405 [FDATE] => 15-JUL-01 [ACTYPE] => C172 [ACID] => N17SJ [NLANDINGS] => 1 [NHOURS] => 1.2 ) 

So everything is uppercase where you're expecting lower case.

while ($newArray = oci_fetch_assoc($result))
{
     foreach ($fields as $field){
       $field = strtoupper($field);
       echo $newArray[$field] . "\n";

not an ideal solution but it'll work.


> thanks for the print_r tip!
> 
> I need to fix 
> 
>  ${$field} = $newArray[$field];     ?? i need to properly use the association
> 
> I have seen no mention of the syntax ${$field} even though it looks reasonable!

Variable variables 
(http://www.php.net/manual/en/language.variables.variable.php).

-- 
Postgresql & php tutorials
http://www.designmagick.com/