|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-03-11 09:19 UTC] sniper@php.net
[2004-03-16 11:59 UTC] sniper@php.net
|
|||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Nov 25 19:00:02 2025 UTC |
Description: ------------ Executing SQL query and trying to move next SQL query but after this query db connection is closed and you can't open db connection again. This problem come's always after that kind of query. Reproduce code: --------------- $result = mssql_query( "if exists (select kuvaurl from kuvagalleria where koiraid = $koiraID and oletus = '1') begin select kuvaurl from kuvagalleria where koiraid = $koiraID and oletus = '1' end else select '00091' as kuvaurl" ); while ($a_row = mssql_fetch_array( $result ) ) { $kuvaurl = "$a_row[kuvaurl]"; } Expected result: ---------------- I'd like to make another SQL query. Actual result: -------------- DB connection is closed and you can't execute any SQL query after that code in same page like it should. Problem is not in SQL Server, the code do sth what anybody doesn't understand.