I have executed a query to an odbc souce and within this query I am trying to loop another query to the same database but looking at different tables but it errors when it tries to use the second query.
I am using a different connection as shown below, but it will not work.
$connect = odbc_connect("FreeTDS", "odbcadm", "");
$connect2 = odbc_connect("FreeTDS", "odbcadm", "");
Perform second query
End the loop
The second query never gets executed and errors occur as the first result set appears to be lost
Thanks for any help.