You are here: Home // Microsoft SQL Server functions
mssql_select_db
(PHP3 , PHP4 )
mssql_select_db – Select MS SQL database
Description
int mssql_select_db (string database_name [, int link_identifier])
Returns: true on success, false on error
Mssql_select_db() sets the current active database on the server that’s associated with the specified link identifier. If no link identifier is specified, the last opened link
mssql_result
(PHP3 , PHP4 )
mssql_result – Get result data
Description
int mssql_result (int result, int i, mixed field)
Mssql_result() returns the contents of one cell from a MS SQL result set. The field argument can be the field’s offset, the field’s name or the field’s table dot field’s name (tablename.fieldname). If the column name has been aliased (’select
mssql_query
(PHP3 , PHP4 )
mssql_query – Send MS SQL query
Description
int mssql_query (string query [, int link_identifier])
Returns: A positive MS SQL result identifier on success, or false on error.
Mssql_query() sends a query to the currently active database on the server that’s associated with the specified link identifier. If the link identifier isn’t specified,
mssql_pconnect
(PHP3 , PHP4 )
mssql_pconnect – Open persistent MS SQL connection
Description
int mssql_pconnect ([string servername [, string username [, string password]]])
Returns: A positive MS SQL persistent link identifier on success, or false on error.
Mssql_pconnect() acts very much like mssql_connect() with two major differences.
First, when connecting, the function
mssql_num_rows
(PHP3 , PHP4 )
mssql_num_rows – Get number of rows in result
Description
int mssql_num_rows (string result)
Mssql_num_rows() returns the number of rows in a result set.
mssql_num_fields
(PHP3 , PHP4 )
mssql_num_fields – Get number of fields in result
Description
int mssql_num_fields (int result)
Mssql_num_fields() returns the number of fields in a result set.
mssql_min_message_severity
(PHP3 , PHP4 )
mssql_min_message_severity – Sets the lower message severity
Description
void mssql_min_message_severity (int severity)
mssql_min_error_severity
(PHP3 , PHP4 )
mssql_min_error_severity – Sets the lower error severity
Description
void mssql_min_error_severity (int severity)
mssql_get_last_message
(PHP3 , PHP4 )
mssql_get_last_message – Returns the last message from server (over min_message_severity?)
Description
string mssql_get_last_message (void )
mssql_free_result
(PHP3 , PHP4 )
mssql_free_result – Free result memory
Description
int mssql_free_result (int result)
mssql_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















































