ID: 45756 User updated by: jochem dot blok at fasterforward dot nl Reported By: jochem dot blok at fasterforward dot nl Status: Open Bug Type: MSSQL related Operating System: Debian PHP Version: 5.2.6 New Comment:
Btw. FreeTDS is used described in the manual: http://nl2.php.net/manual/en/mssql.setup.php Previous Comments: ------------------------------------------------------------------------ [2008-08-08 07:18:08] jochem dot blok at fasterforward dot nl Description: ------------ See reproduce code. The query is executed 2 times on resource $r2. Reproduce code: --------------- $r1 = mssql_connect('my_server', 'my_user', 'my_pass'); mssql_select_db('database_1', $r1); $r2 = mssql_connect('my_server', 'my_user', 'my_pass'); mssql_select_db('database_2', $r2); $sSql = 'select count(*) as total from my_table'; $rRes1 = mssql_query($sSql, $r1); $oRow1 = mssql_fetch_object($rRes1); echo '1: '.$oRow1->total.'<br>'; $rRes2 = mssql_query($sSql, $r2); $oRow2 = mssql_fetch_object($rRes2); echo '2: '.$oRow2->total.'<br>'; Expected result: ---------------- Different total. Actual result: -------------- Same total. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=45756&edit=1
