Web Standards Programmer's Reference: HTML, CSS, JavaScript®, Perl, Python®, and PHP

F.23. MS SQL

Function	Returns	Description
mssql_connect([string servername [, string username [, string password]]])	int	Establishes a connection to an MS-SQL server.
mssql_pconnect([string servername [, string username [, string password]]])	int	Establishes a persistent connection to an MS-SQL server.
mssql_close([resource conn_id])	bool	Closes a connection to an MS-SQL server.
mssql_select_db(string database_name [, resource conn_id])	bool	Select an MS-SQL database.
mssql_fetch_batch(resource result_index)	int	Returns the next batch of records.
mssql_query(string query [, resource conn_id [, int batch_size]])	resource	Performs an SQL query on an MS-SQL server database.
mssql_rows_affected(resource conn_id)	int	Returns the number of records affected by the query.
mssql_free_result(resource result_index)	bool	Frees an MS-SQL result index.
mssql_get_last_message(void)	string	Gets the last message from the MS-SQL server.
mssql_num_rows(resource mssql_result_index)	int	Returns the number of rows fetched in from the result_id specified.
mssql_num_fields(resource mssql_result_index)	int	Returns the number of fields fetched in from the result_id specified.
mssql_fetch_row(resource result_id)	array	Returns an array of the current row in the result set specified by result_id.
mssql_fetch_object(resource result_id [, int result_type])	object	Returns a psuedo-object of the current row in the result set specified by result_id.
mssql_fetch_array(resource result_id [, int result_type])	array	Returns an associative ...