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/ I am new to PHP and I was wondering if an array can contain dissimilar types while ($newArray = oci_fetch_assoc($result)) { surely a DB row might contain : create table log_book_id ( log_id number primary key, fdate date, actype varchar2(16), acid varchar(16), nlandings number, nhours number); insert into log_book_id values (logid.nextval, TO_DATE('08/12/1973','MM/dd/YYYY'),'C150','N5787G',1,1.8);