tamilmani Posted May 25, 2011 Share Posted May 25, 2011 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.