Hi ppl.
I have something which seems really odd.
I run a SQL query, which is supposed to return 2 rows, but instead, it
returns one with
OCIFetchInto(). I used the exact same query in SQL*Plus, and It returns 2
rows like I want them.
Here's the code.
if(!$iDBConn = OCILogon(DB_USER, DB_PASS, DB_NAME))
echo "Failed to connect to Oracle database<br>";
$stmt = OCIParse($iDBConn,"ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'");
OCIExecute($stmt,OCI_DEFAULT);
$orasql = "SELECT * FROM gaj_ledjer_potongan WHERE no_gaji =
'".$id["salary_no"].
"' AND kod_potongan = '09' AND tempoh_gaji LIKE '$year%'";
echo $orasql."<br>";
$iStatement = @OCIParse($iDBConn, $orasql);
@OCIExecute($iStatement, OCI_DEFAULT);
$arrError = OCIError($iStatement);
if ($arrError['code']) {
print $arrError['message'];
exit;
}
$total_ded_sal = 0;
$deduction = $id["deduction"];
while(OCIFetchInto($iStatement, &$ora, OCI_ASSOC+OCI_RETURN_NULLS)) {
echo $ora['TEMPOH_GAJI']."<br>";
}
p/s - I tried using a select * from table, and it returns more than one
rows(i suppose all the rows).
Thanks.
______________________________________
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
