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

Reply via email to