Need help in to execute the SP ?

May 26, 2011 at 6:53 AM


Sample PHP code is



$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.


Tamilmani Mohan