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

--- On Mon, 11/24/08, Chris <[email protected]> wrote:

> From: Chris <[email protected]>
> Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1
> To: [email protected]
> Cc: [email protected]
> Date: Monday, November 24, 2008, 6:41 AM
> Fred Silsbee wrote:
> 
> >     while ($newArray = oci_fetch_assoc($result)) {
> >         foreach ($fields as $field){                  
>        ${$field} = $newArray[$field];        // values not
> making it into variable
> >                      }                                
>         
> 
> print_r($newArray);
> 
> what is here?
> 
> Oracle uppercases all fields, tablenames by default (per
> sql spec).
> 
> -- Postgresql & php tutorials
> http://www.designmagick.com/


That code showed all...THANKS!

The data is being extracted but not making it to the variables.

    while ($newArray = oci_fetch_assoc($result)) {
        print_r($newArray);                 // everything!!! is there
        foreach ($fields as $field){
            ${$field} = $newArray[$field];    // here...works under MySQL
        }