#18928 [Opn->Bgs]: mssql_num_rows() doesn't work

ID: 18928 Updated by: kalowsky@php.net Reported By: matthius@u.washington.edu -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Win2k Server PHP Version: 4.2.2 New Comment: I'm not a MSSQL user, so I don't know the specifics of that query string. But if the query fails, of course you'll receive this error message from MSSQL.... the result set isn't populated, thus there is nothing to retrieve. Unless you can show this error message to work with a valid SQL query, I'm going to mark this as Bogus. If you can, you're welcome to re-open the bug and add this new information. Previous Comments: ------------------------------------------------------------------------ [2002-08-15 17:40:45] matthius@u.washington.edu 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 this bug report at http://bugs.php.net/?id=18928&edit=1