From: [EMAIL PROTECTED]
Operating system: win2000 sp2
PHP version: 4.2.0
PHP Bug Type: ODBC related
Bug description: odbc_fetch_row fails when parameters 2 set
The following code works for the first sql statement however fails on the
odbc_fetch_row for the second when the second parmeter is set. This works
for php4.1.2 but fails on php4.2.0
ODBC connected to Access97 database, running Apache2
----------------------------------------------------
CODE
----------------------------------------------------
$DB_TMS = odbc_connect("tms", "", "");
$sql = "select * from users where name='Root' and pass='1111'";
$res = odbc_exec($DB_TMS, $sql);
if( odbc_fetch_row($res)) echo "Found Record <br>";
else echo "No Record Found <br> ";
odbc_free_result($res);
$sql = "select * from users where name='Root' and pass='1111'";
$res = odbc_exec($DB_TMS, $sql);
if( odbc_fetch_row($res, 1)) echo "Found Record <br>";
else echo "No Record Found <br> ";
odbc_free_result($res);
odbc_close_all( );
--
Edit bug report at http://bugs.php.net/?id=16742&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=16742&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=16742&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=16742&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=16742&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16742&r=support
Expected behavior: http://bugs.php.net/fix.php?id=16742&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=16742&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=16742&r=submittedtwice