How to connect to mssql databases and select available one?

Question

PHP

Hello everyone . There is a site that works on
1 mssql database, everything is fine, but there are situations when the server is unavailable, then you need to switch quickly and get answers exactly from another copy of the server .

$link = mssql_connect($db_host,$db_user,$db_pass,true) or $link = mssql_connect($db_host1,$db_user,$db_pass,true);

  @mssql_select_db($db1_name,$link) or @mssql_select_db($db2_name,$link);

  $res = @mssql_query('Set language Russian');

  @mssql_free_result($res);

Answer 1

$link = mssql_connect($db_host,$db_user,$db_pass,true);
if ($link) {
@mssql_select_db($db1_name,$link)
} else {
$link = mssql_connect($db_host1,$db_user,$db_pass,true);
@mssql_select_db($db2_name,$link);
}
$res = @mssql_query('Set language Russian');
@mssql_free_result($res);