Using a stored procedure in MSSQL...which works...how do I return the results...
if ($zip_found && $zip) {
$stmt = mssql_init("find_agents",$connection) or DIE("FAILED TO EXECUTE STORED PROCEDURE.");
mssql_bind($stmt,"@",&$zip,SQLCHAR,FALSE);
mssql_bind($stmt,"@Dist",&$miles,SQLFLT8,FALSE);
if ($stmt) { echo "hello world<br><br><br>"; } else { echo "bad world"; };
$results_sp = mssql_execute($stmt);
if ($results_sp) {
while ($row = mssql_fetch_row($results_sp)) { //line 117
echo $row[0];
};
}
else { echo "bad world"; };
};
I get:
Warning: Supplied argument is not a valid MS SQL-result resource in c:\inetpub\wwwroot\find_an_agent\results_sp.nycm on line 117
of course below it prints "bad world".
Thanks for any help.
