Database connection

[Marcel]

<?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",$c onnecttest) 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",$c onnectprod) or exit("Unable to
select database PROD");
$SQL = "SELECT * FROM table1";

$RESULT = mssql_query($SQ L);
// 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?

?>

[Steve]

// 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?

It will be from the most recently opened resource, but if you are ever
in any doubt then explicitly state which connection to use...

$RESULT = mssql_query($SQ L,$connectprod) ;

---
Steve

[Meiao]

If you use PEAR's DB
you can use 2 connections at a time (i think)

[Marcel]

"Steve" <go********@nas tysoft.com> schreef in bericht
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .

// 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?

It will be from the most recently opened resource, but if you are ever
in any doubt then explicitly state which connection to use...

$RESULT = mssql_query($SQ L,$connectprod) ;

---
Steve

Ok thanks a lot!