How do I post results of a stored procedure on my PHP page. I have it doing the query, but I can't get the any of the results to post.
I have:
$stmt = mssql_init("find_agents",$connection);
mssql_bind($stmt,"@",&$zip,SQLCHAR,FALSE);
mssql_bind($stmt,"@Dist",&$miles,SQLFLT8,FALSE);
$result = mssql_execute($stmt);
if($result){
$row = mssql_result($result);
echo $row[0];
};
And I get...
Warning: Wrong parameter count for mssql_result() in c:\inetpub\wwwroot\find_an_agent\results_sp.nycm on line 114
Anyone with experience pulling this information back out. Thank you so much!
