JavaScript Editor Javascript debugger     Website design 


Send MS SQL query (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
mixed mssql_query ( string query [, resource link_identifier [, int batch_size]] )

mssql_query() sends a query to the currently active database on the server that's associated with the specified link identifier.



A SQL query.


A MS SQL link identifier, returned by mssql_connect() or mssql_pconnect().

If the link identifier isn't specified, the last opened link is assumed. If no link is open, the function tries to establish a link as if mssql_connect() was called, and use it.


The number of records to batch in the buffer.

Return Values

Returns a MS SQL result resource on success, TRUE if no rows were returned, or FALSE on error.



If the query returns multiple results then it is necessary to fetch all results by mssql_next_result() or free the results by mssql_free_result() before executing next query.