Re: works under mysql 5 but not under Oracle 11g1

--- On Mon, 11/24/08, Chris <dmagick@gmail.com> wrote: > From: Chris <dmagick@gmail.com> > Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 > To: fredsilsbee@yahoo.com > Cc: php-db@lists.php.net > 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 }