Posted by Chad L on 11/17/05 05:38

I'm trying to execute a SQL stored procedure from PHP like so:

$sql = "exec ('usp_Locations_Sel 5065')";

if (! $result = mssql_query($sql,$DBid))
{
exit;

}

while( $row = mssql_fetch_array($result) ){
// blah blah

}

The Procedure works from SQL Query Analyzer, and returns a result set
of 4 rows. Other stored procedures, in which a single variable is
declared for return, also come back to PHP without any problem.
However, any procedure that returns a result set doesn't make it back
to PHP.

(I don't have mssql_bind(), etc)

Any help would be much appreciated.
CL

[Back to original message]