title: mssql_execute returns no results - better way to debug?
body: <p>My connection is established, and I can call my stored procedure:</p>
  
  <pre><code>$pid = $_GET['pid'];
  $conn = mssql_connect($server, $username, $password);
  ...
  mssql_select_db('mydb',$conn);
  
  $sproc = mssql_init('consultGetPatientData');
  mssql_bind($sproc, '@pid', $pid, SQLINT2);
  
  $result = mssql_execute($sproc);
  echo mssql_num_rows($result);
  if($result){    
      $row = mssql_fetch_assoc($result);      
  ...
  </code></pre>
  
  <p>My <code>$pid</code> value is being passed correctly. 
  The <code>$result</code> value being is <code>var_dump</code>:</p>
  
  <pre><code>resource(3) of type (mssql result) 
  </code></pre>
  
  <p>And <code>msql_num_rows($result)</code> yields 0 rows.</p>
  
  <p>The user connecting to the database has sufficient access to the <code>consultGetPatientData</code> stored procedure:</p>
  
  <p><img src="https://i.stack.imgur.com/VvBnm.png" alt="Properties"></p>
  
  <p>When I manually run the stored procedure, desired results are being returned. My </p>
  
  <p>My questions:</p>
  
  <p><strong>Is there a better way to debug these types of errors?</strong></p>
  
  <p><strong>Is there anything glaring I am missing?</strong></p>
  
  <p>Thank you.</p>
  
  <p>EDIT: stored procedure code as requested:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[consultGetPatientData] 
      @pid int = 0    
  AS
  BEGIN   
      SET NOCOUNT ON;
  
  select 
      pd.pid, 
      pd.external_id,
      pd.fname, 
      pd.lname, 
      pd.DOB, 
      pd.ss, 
      pd.sex,
      pd.allergies,
      pb.date,
      pb.release
  from 
      patient_data pd 
          inner join patient_booking_data pb on pd.pid = pb.pid
  where 
      pd.pid = @pid
      and pb.date in (
          select MAX(date) from patient_booking_data where pid = @pid
      )
  END
  </code></pre>