#19015 [NEW]: IF Statement fails in mssql_query()

From: joe.binnington@xko.co.uk Operating system: Windows 2000 PHP version: 4.2.2 PHP Bug Type: MSSQL related Bug description: IF Statement fails in mssql_query() 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 bug report at http://bugs.php.net/?id=19015&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19015&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19015&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19015&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19015&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19015&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19015&r=support Expected behavior: http://bugs.php.net/fix.php?id=19015&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19015&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19015&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19015&r=globals