#19015 [Bgs->Opn]: IF Statement fails in mssql_query()

ID: 19015 User updated by: joe.binnington@xko.co.uk Reported By: joe.binnington@xko.co.uk -Status: Bogus +Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.2.2 New Comment: This is not a support question. The second query should work but doesn't. It is not because the SQL is incorrect, it is because the mssql_query() function in php_mssql.dll does not process the second query correctly. Previous Comments: ------------------------------------------------------------------------ [2002-08-21 07:15:27] jan@php.net Sorry, but the bug system is not the appropriate forum for asking support questions. Your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php Thank you for your interest in PHP. ------------------------------------------------------------------------ [2002-08-21 07:11:19] joe.binnington@xko.co.uk This query works: select * from tablename ...but this query doesn't: if (1=1) select * from tablename Apparently, in the second query, two results are returned, the first is empty, the second is the correct result set. I know that I could put the IF statement directly into PHP but there are good reasons why we need them to work within the SQL statement. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19015&edit=1