can't get stored procedure return value

[Anon]

I can't get the return value from SQL Server 7.0 stored procedures in PHP. Is these some trick that I'm missing or is there a bug in PHP?

[opido]

Please paste some code.

[Anon]

  //Begin Transaction
  if ($UseTrans == "YES") 
     {
     SaveLogData("---BEGIN---");
     MsSql_Query("BEGIN TRANSACTION", $MsSqlLink);
     } 
  //Execute Query
  $RecordSet = MsSql_Query($SqlStr, $MsSqlLink);
  if ($RecordSet === FALSE)  //<<--it seems like $RecordSet never contains the stored procedure's "return" value
     {
     if ($UseTrans == "YES") MsSql_Query("ROLLBACK", $MsSqlLink);
     SaveLogData($SqlStr, "YES");
     if ($UseTrans == "YES") SaveLogData("---ROLLBACK---");
     return FALSE;
     } 
  //Commit transaction
  SaveLogData($SqlStr);
  if ($UseTrans == "YES") 
     {
     MsSql_Query("COMMIT", $MsSqlLink);
     SaveLogData("---COMMIT---");
     }

[[deleted]]

Classic mistake; mssql_query() does NOT return any results, it returns a result identifier, like a filepointer.

RTM:
http://www.php.net/manual/en/function.mssql-query.php

[Anon]

How can you get the stored procedure return value from the result identifier? Is there some function I can pass the result identifier to?

[[deleted]]

The stored procedure returns results, just like any other query...

[Anon]

a stored procedure can return any of three types of "results":

1) a results set (like a query) containing rows and columns of data.
2) output parameters which the stored procedure has changed since it was called
3) a return value, the optional integer value that was supplied to the "return" command inside the procedure

my question all along has been how do I get #3 (from the list above) from PHP and a SQL Server stored procedure???