Could not able to read SP record set result

[tamilmani]

Hi Everyone,

 

This is Tamilmani Mohan , i have an issue in to read the SP record set result by using SQLSRV queries.

 

Sample PHP code is

<?php

$para = array(array($memberid,SQLSRV_PARAM_IN),

array($start_date,SQLSRV_PARAM_IN),

array($end_date,SQLSRV_PARAM_IN)

);

$stmt =  "{call MemberStatement(?, ?, ?)}";

if(!($result= sqlsrv_query($conn,$stmt ,$para)))

{

echo "Database Error"; die;

}

$arr_main = array();

$totalpoints =0;

 

while($row = sqlsrv_fetch_array($result))

{

$arr_main[] =  $row;

$totalpoints = $totalpoints + $row['member_points'];

 

}

 

?>

When i execute the above i don't get any result. But if i run the above SP in management studio , i am able to see the result(8 rows are coming).

I don't know the reason , why i don't get any result?

Please any one give me the solution for this problem.

 

Regards

Tamilmani Mohan