--- On Mon, 11/24/08, Chris <dmagick@xxxxxxxxx> wrote: > From: Chris <dmagick@xxxxxxxxx> > Subject: Re: works under mysql 5 but not under Oracle 11g1 > To: fredsilsbee@xxxxxxxxx > Cc: php-db@xxxxxxxxxxxxx > 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 } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php