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
Copyright © 2010 PHP Manual. SiteMap.
Designed by Web Design SiteConstruct. Powered by WordPress.