Hi!!

I am trying to get some information in a stored in a MSSQL server and I am using PHP in another server to communicate each other.

I think I have to use the function mssql_execute, but the problem is that I don´t know why I don´t obtain no info from the stored.

My code is:

<?php

$myServer = "192.168.88.4";
$myUser = "estracom";
$myPass = "comerciales";
$myDB = "smsdb";

$conn = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");

if ($conn) {
mssql_select_db($myDB, $conn) or die("Couldn't open database $myDB");

$stmt=mssql_init("sp_fichasEstrategiasCom",$conn);

$result=mssql_execute($stmt);

$arr=mssql_fetch_row($result);
print ("Answer: " . $arr[0] . "<br>" );

mssql_close($conn);
}
else print("No connection");

?>