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/

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);