PHP 4.0 Bug #8022: mssql_query seems to be fail with sql statement "set"

From: lingc@mail.nsysu.edu.tw Operating system: winnt 4.0 sp4+apache1.3.14+mssql7.0sp2 PHP version: 4.0.3pl1 PHP Bug Type: MSSQL related Bug description: mssql_query seems to be fail with sql statement "set" I need to exec my sql statement with "set nocount on" and "set nocount off" within the for-loop by the function of mssql_query. But it seems only to be successful at the first time and the others were failed with the error message "MSSQL Query Failed". My platform is WinNT4.0sp4+Apache1.3.14+Php4.03pl1+MSSQL7.0sp2. The sql-statement is <pre> $db = mssql_connect("test","",""); for ($i=0;$i<=3;$i++){ $SQLstr = "set nocount on select news from table_news set nocount off"; $result = mssql_query($SQLstr,$db); print $result; } mssql_close($db); ======================== The result is: 1 Warning: MS SQL: Query failed in c:\test.php3 on line 16 Warning: MS SQL: Query failed in c:\test.php3 on line 16 </pre> I use the mssql profiler to trace the execution. I found that the sql statement was only executed at the first time and another times were not found. Is this is a bug of mssql_query ? Thanks anyway, Vicent,Lin. -- Edit Bug report at: http://bugs.php.net/?id=8022&edit=1