<HTML ><HEAD ><TITLE >mssql_select_db</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="Microsoft SQL Server functions" HREF="ref.mssql.html"><LINK REL="PREVIOUS" TITLE="mssql_rows_affected" HREF="function.mssql-rows-affected.html"><LINK REL="NEXT" TITLE="Ming functions for Flash" HREF="ref.ming.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation 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-rows-affected.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="ref.ming.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.mssql-select-db" ></A >mssql_select_db</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN52361" ></A ><P > (PHP 3, PHP 4 )</P >mssql_select_db -- Select MS SQL database</DIV ><DIV CLASS="refsect1" ><A NAME="AEN52364" ></A ><H2 >Description</H2 >int <B CLASS="methodname" >mssql_select_db</B > ( string database_name [, int link_identifier])<BR ></BR ><P > Returns: <TT CLASS="constant" ><B >TRUE</B ></TT > on success, <TT CLASS="constant" ><B >FALSE</B ></TT > 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 SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.mssql-rows-affected.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="ref.ming.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >mssql_rows_affected</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.mssql.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Ming functions for Flash</TD ></TR ></TABLE ></DIV ></BODY ></HTML >