--- 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 Silsbee wrote:
while ($newArray
--- 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 Silsbee wrote:
while ($newArray
--- 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 Silsbee wrote:
while ($newArray
--- 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, November 24, 2008, 2:44 PM
--- On Mon, 11/24/08, 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 =
--- 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
fixed the problem but am not fully sure
--- 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, November 24, 2008, 10:31 PM
--- On Mon, 11/24/08, 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);
Fred Silsbee wrote:
while ($newArray = oci_fetch_assoc($result)) {
foreach ($fields as $field){
${$field} = $newArray[$field];// values not making it into variable
}