<div>
For most of the time I need use DBa, sometimes I need to use DBa and DBb.<br />
<br />
I am not sure how this will switch the link identifier. Where to I get the resource from?<br />
<br />
But once I have the $db_resource I can pass it to the query and MSSQL will switch.<br />
mysql_query($sql, $db_resource);<br />
<br />
Thanks hernst42
</div>


For most of the time I need use DBa, sometimes I need to use DBa and DBb.

I am not sure how this will switch the link identifier. Where to I get the resource from?

But once I have the $db_resource I can pass it to the query and MSSQL will switch.
mysql_query($sql, $db_resource);

Thanks hernst42

<div>
I ended up just reconnecting.
</div>


<div>
<div class="content wysiwyg-content">
PHP and MSSQL<br />
I developed a class that works exactly how I would like it to. The limitation is switching cross db servers. I asked a similar question earlier this week for switching databases, after a few replies I found the USE condition, and it worked.<br />
<br />
Any ideas how I can maintain two database connections to different servers?<br />
<br />
Please don't just send me to the API. I more of a designer than a developer, so simple OOP methods would be preferred.<br />
<br />
Thanks in advance guys (and gals).
</div>
</div>


PHP and MSSQL
I developed a class that works exactly how I would like it to. The limitation is switching cross db servers. I asked a similar question earlier this week for switching databases, after a few replies I found the USE condition, and it worked.

Any ideas how I can maintain two database connections to different servers?

Please don't just send me to the API. I more of a designer than a developer, so simple OOP methods would be preferred.

Thanks in advance guys (and gals).

Switching Between Database Servers using PHP

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.