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

2008-11-24 Thread Chris
Array ( [LOG_ID] => 405 [FDATE] => 15-JUL-01 [ACTYPE] => C172 [ACID] => N17SJ [NLANDINGS] => 1 [NHOURS] => 1.2 ) So everything is uppercase where you're expecting lower case. while ($newArray = oci_fetch_assoc($result)) { foreach ($fields as $field){ $field = strtoupper($field);

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

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Fred Silsbee <[EMAIL PROTECTED]> wrote: > From: Fred Silsbee <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 > To: "Chris" <[EMAIL PROTECTED]> > Cc: php-db@lists.php.net > Date: Monday, N

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

2008-11-24 Thread Fred Silsbee
--- 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: php-db@lists.php.net > Date: Monday, November 24, 2008, 10:00 PM > > f

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

2008-11-24 Thread Chris
fixed the problem but am not fully sure of the optimum code one should use! I like the association idea but must change the $fields array There is a better way than using count! 67 //get log_book_id table information 68 $user = "select * from log_book_id"; 69 $result = oci

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

2008-11-24 Thread Fred Silsbee
--- On Mon, 11/24/08, Fred Silsbee <[EMAIL PROTECTED]> wrote: > From: Fred Silsbee <[EMAIL PROTECTED]> > Subject: Re: [PHP-DB] works under mysql 5 but not under Oracle 11g1 > To: "Chris" <[EMAIL PROTECTED]> > Cc: php-db@lists.php.net > Date: Monday,

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

2008-11-24 Thread Fred Silsbee
--- 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: php-db@lists.php.net > Date: Monday, November 24, 2008, 6:41 AM > Fred S

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

2008-11-24 Thread Fred Silsbee
--- 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: php-db@lists.php.net > Date: Monday, November 24, 2008, 6:41 AM > Fred S

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

2008-11-24 Thread Fred Silsbee
--- 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: php-db@lists.php.net > Date: Monday, November 24, 2008, 6:41 AM > Fred S

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

2008-11-23 Thread Chris
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);

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

2008-11-23 Thread Fred Silsbee
//construct a global variable for the form profile $fields = array("fdate", "actype", "acid", "nlandings", "nhours"); problem down in while loop .. . . . . . function displayDeleteForm(){ //get $fields into the function namespace global $fields; global $co