I'm write a query for take some result in mssql server ,that working but now they some errors ,the error is
Warning: mssql_fetch_array(): 3 is not a valid MS SQL-result resource in
my connection query is working and there is no problem, my query like this
$qry="select cd_pcp,pcp_nm from tbl_m_pcp order by cd_pcp asc";
$result=mssql_query($qry);
while($row1=mssql_fetch_array($result))
{
echo $row1['cd_pcp'];
}
var_dump the $result show
resource(3) of type (mssql result)
the query is execute in sql-server whyshow this type error any way to solve this issue please help me?