Apparently php handles results of a normal select query and a call to a stored procedure differently as I can't seem to get to the data returned.
$result = odbc_exec($con, $sql);
//echo odbc_result($result,'ABNAME'); at least this gives the store name
echo"store:".$storen." store#:".$storenum."<br />";
The commented out line is as close as I have gotten to "seeing" the data. odbc_fetch_row apparently does not work as nothing happens when the code runs.
I can loop and increment $num_stores to the correct number of records returned (4). odbc_num_rows returned -1 so I had to loop to count the records returned.
Any suggestions on how I can loop through the returned records? The stored procedure returns the store name as well as store number.