Okay...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($result){
while ($row = mssql_fetch_row($result)) {
echo $row[0];
};
};
and get back...
Warning: Supplied argument is not a valid MS SQL-result resource in c:\inetpub\wwwroot\find_an_agent\results_sp.nycm on line 112
I think the mssql_fetch_row is wrong in this case as I've generated the results in the stored procedure...I just don't know the function to appropriately get them back to my page.
Thank you!