Bug #10416: Fetch_cursor return second record not first.
| From: | tomasz dot fadrowski at dtcentrum dot com | Date: | Fri, 20 Apr 2001 08:26:04 +0000 |
| Subject: | Bug #10416: Fetch_cursor return second record not first. | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-52038@lists.php.net to get a copy of this message | ||
From: tomasz.fadrowski@dtcentrum.com
Operating system: WINNT, WIN98, Aix
PHP version: 4.0.4pl1
PHP Bug Type: Oracle related
Bug description: Fetch_cursor return second record not first.
When I try display records from cursor connected to oracle by function "Ora_logon" my
results of all records display from second to last rows - not display first row.
Simple code :
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<body>
<?php
PUTENV("ORACLE_HOME=D:\\ORANT\\");
$CONNECTION=Ora_logon("user/password@db","");
$SQL="SELECT rownum, artean13, artlibl FROM artdgene";
$CURSOR=ORA_DO($CONNECTION,$SQL);
WHILE(ORA_FETCH($CURSOR))
{
PRINT(ORA_GETCOLUMN($CURSOR,0));print("
");print(ORA_GETCOLUMN($CURSOR,1));print(ORA_GETCOLUMN($CURSOR,2));
print("<BR>");
}
ORA_CLOSE($CURSOR);
ORA_LOGOFF($CONNECTION);
?>
</body>
</html>
--
Edit Bug report at: http://bugs.php.net/?id=10416&edit=1