MSSQL only allows one HRESULT open per connection. If you have a query with a server side cursor open any subsequent queries using that connection will fail.
mssql_free_result
(PHP 4, PHP 5, PECL odbtp >= 1.1.1)
mssql_free_result — Free result memory
Ostrzeżenie
Ta funkcja została USUNIĘTA w PHP 7.0.0.
Alernatywy dla tej funkcji obejmują:
Opis
mssql_free_result
( resource
$result
) : boolmssql_free_result() only needs to be called if you are worried about using too much memory while your script is running. All result memory will automatically be freed when the script ends. You may call mssql_free_result() with the result identifier as an argument and the associated result memory will be freed.
Parametry
-
result -
The result resource that is being freed. This result comes from a call to mssql_query().
Zwracane wartości
Zwraca TRUE w przypadku powodzenia, FALSE w
przypadku błędu.
Przykłady
Przykład #1 mssql_free_result() example
<?php
// Select some data from a table
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]', $link);
// Handle query result here
// When we're done we free the result by calling
// mssql_free_result like so:
mssql_free_result($query);
?>
add a note
User Contributed Notes 1 note
veggivore [at] yahoo [period] com ¶
17 years ago
