Posted by Marcel on 10/18/05 11:21

<?php

I have a question about 2 connection strings to a ms sql database.

# TEST DATABASE

$connecttest = MSSQL_CONNECT("TEST", "sa", "123456") or exit("Unable to
connect to MS SQL Server at 10.0.10.58");

$select = mssql_select_db ("database1",$connecttest) or exit("Unable to
select database TEST");


# PRODUCTION DATABASE

$connectprod = MSSQL_CONNECT("PROD", "sa", "654321") or exit("Unable to
connect to database at 10.0.10.59");

$select = mssql_select_db ("database2",$connectprod) or exit("Unable to
select database PROD");


$SQL = "SELECT * FROM table1";

$RESULT = mssql_query($SQL);


// What data will i find here? Is it data from the TEST or from PROD and
will it be data from database1 or from database 2?

?>

[Back to original message]