MS SQL 2000

Hi all, I have the following problem with PHP using MS SQL 2000. The connection seems to be opened properly, but any usage of returned value from mssql_query() does not work as a parameter for functions like mssql_fetch_array, mssql_num_rows, etc., although it is printed as '1'. -- This piece of code: -- **************************** <? $connection = mssql_connect("ATHLON\LOCALHOST") or die("No connection"); mssql_select_db("db", $connection); echo "Query answer: ".($answer = mssql_query("SELECT * FROM table"))."<br>"; echo mssql_num_rows($answer); ?> **************************** -- produces this page: -- **************************** Query answer: 1 Warning: Supplied argument is not a valid MS SQL-result resource in c:/users/john/php/mr/mssql.php on line 6 **************************** Thank you for any hint -- __________________________________________________________________________________________ ========================================================================================== Jan Walter, called John LERACH, s.r.o. phone nr. work: +420-2-78 22 619, home: +420-2-35 35 27 61 on emergency call cell phone: +420-602-385 760 work e-mail mailto:Jan.Walter@lerach.cz private e-mail mailto:john@lerach.cz ICQ#: 28353428 __________________________________________________________________________________________ ==========================================================================================