What was the error message you received? Also, when passing the variables to the mssql_connect() function, you need not use quotes since you've already initialized them to the strings. Pass them as follows: $connection = mssql_connect($a,$b,$c). Also, you aren't passing the actual sql string to the mssql_query() function. You have $sql = "blah" but you pass $sql_temp.
"Jerry" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi > > I have PHP on windows 2000 web server > I would like to remote to a MS SQL database on another web server. > I tried something like: > > <?php > $h = "server adr"; > $u = "user"; > $p = "passw"; > $b = "db"; > $connexion = mssql_connect("$h", "$u", "$p"); > mssql_select_db($b); > $sql = "select * from test"; > $result = mssql_query($sql_temp); > mssql_close($connexion); > ?> > > But it didn't work. Please help me. > > Jerry > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]