<HTML ><HEAD ><TITLE >mssql_select_db</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.44"><LINK REL="HOME" TITLE="PHP Manual" HREF="manual.html"><LINK REL="UP" TITLE="Microsoft SQL Server functions" HREF="ref.mssql.html"><LINK REL="PREVIOUS" TITLE="mssql_result" HREF="function.mssql-result.html"><LINK REL="NEXT" TITLE="Miscellaneous functions" HREF="ref.misc.html"></HEAD ><BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.mssql-result.html" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="ref.misc.html" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.mssql-select-db" >mssql_select_db</A ></H1 ><DIV CLASS="refnamediv" ><A NAME="AEN17163" ></A >mssql_select_db -- Select MS SQL database</DIV ><DIV CLASS="refsect1" ><A NAME="AEN17166" ></A ><H2 >Description</H2 ><DIV CLASS="funcsynopsis" ><P ></P ><CODE CLASS="FUNCDEF" >int mssql_select_db</CODE >(string database_name, int [<SPAN CLASS="optional" >link_identifier</SPAN >] );<P ></P ></DIV ><P > Returns: true on success, false on error </P ><P > <B CLASS="function" >Mssql_select_db()</B > 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 is assumed. If no link is open, the function will try to establish a link as if <A HREF="function.mssql-connect.html" ><B CLASS="function" >mssql_connect()</B ></A > was called, and use it. </P ><P > Every subsequent call to <A HREF="function.mssql-query.html" ><B CLASS="function" >mssql_query()</B ></A > will be made on the active database. </P ><P > See also: <A HREF="function.mssql-connect.html" ><B CLASS="function" >mssql_connect()</B ></A >, <A HREF="function.mssql-pconnect.html" ><B CLASS="function" >mssql_pconnect()</B ></A >, and <A HREF="function.mssql-query.html" ><B CLASS="function" >mssql_query()</B ></A > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.mssql-result.html" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="manual.html" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="ref.misc.html" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >mssql_result</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.mssql.html" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Miscellaneous functions</TD ></TR ></TABLE ></DIV ></BODY ></HTML >