query

[jimdy]

I dont think the quey is wrong. I tried a very simple query and it works in a sql console but not in php.

[Wien]

so it's very likely to be a PHP problem but I need your code to help you more

[jimdy]

$SQL_connString="SQLOLEDB;DBMSSOCN;xxx.xx.xx.xx;telecomordersdb;agentconn;xxxxxxxxx";

list($Provider, $Network, $DataSource, $InitialCatalog, $UserId, $Password)=split(';' , $SQL_connString);

$conn=mssql_connect($DataSource,$UserId,$Password) or die("Couldn't connect to server.");

mssql_select_db($InitialCatalog,$conn);
$sAgentID="ufo0008";

$sSQL= "IF 'ufo0008' IN (SELECT AgentID FROM telecom1.Agents) SELECT CompanyName FROM telecom1.Agents";

$rs_query=mssql_query($sSQL,$conn) or die("failed");
echo $result_rows=mssql_num_rows($rs_query);
$rs = mssql_fetch_array($rs_query);
$sCompanyName=$rs[0];
echo $sCompanyName;

?>

[jimdy]

I forgot to mention rs_query returns 1 which means the query should be working

[Wien]

I don't know !

you could try to fetch
$sCompanyName=$rs["AgentID"];
instead of
$sCompanyName=$rs[0];