note 38089 added to function.mssql-next-result

you cant return multiple values from store proc but you can return multiple resultset, so you can use mssql_next_result() eg.. $stmt = mssql_init("AuthLoginUser", $objDBH); mssql_bind($stmt,"@LoginUser",$LoginUser,SQLVARCHAR); mssql_bind($stmt,"@Password",$strNewPassword,SQLVARCHAR); mssql_bind($stmt,"@SessionId",$SessionId,SQLVARCHAR); //mssql_bind($stmt,"@ReturnVal",$ReturnVal,SQLVARCHAR,True); $rs=mssql_execute($stmt); do { while ($row = mssql_fetch_row($rs)) { echo "$row[0] -- $row[1]<BR>"; } } while (mssql_next_result($rs)); mssql_free_result($rs); ---- Manual Page -- http://www.php.net/manual/en/function.mssql-next-result.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+38089 Delete -- http://master.php.net/manage/user-notes.php?action=delete+38089&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+38089&report=yes Search -- http://master.php.net/manage/user-notes.php