#18928 [NEW]: mssql_num_rows() doesn't work

From: matthius@u.washington.edu Operating system: Win2k Server PHP version: 4.2.2 PHP Bug Type: MSSQL related Bug description: mssql_num_rows() doesn't work Using MSSQL 2000 The function mssql_num_rows generates the following warning: Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource At the advice of the documentation I tried making the following query: $query2 = 'SELECT @@ROWCOUNT'; $result2 = mssql_query($query2); list($affected) = mssql_fetch_row($result2); echo($affected); This generates the following error: Warning: MS SQL: Query failed All other queries work fine I can interact with the database. I have also tried the latest stable build on snaps.php.net as of today 8-15-02 the problem remains unchanged. Any help would be greatly appreciated. Thanks! Matt -- Edit bug report at http://bugs.php.net/?id=18928&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18928&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18928&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18928&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18928&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18928&r=support Expected behavior: http://bugs.php.net/fix.php?id=18928&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18928&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18928&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18928&r=globals