I have the connection and execution of my Stored Procedure happening using IIS,SLQ,PHP. I don't know how to return the results appropriately. I have:
if ($zip_found && $zip) {
$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 get back...
Warning: Wrong parameter count for mssql_result() in c:\inetpub\wwwroot\find_an_agent\results_sp.nycm on line 114
I just know the function to appropriately get the results back to my page.Any example would be highly appreciated!
Thank you!
