|
|
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
Navigation:
[Reply to this message]
|