I would guess you have to use some extra layer of connection pools...
each of those queries should go in a separate sql connection... i
believe...
On Wed, 2003-10-15 at 15:36, Rich Fox wrote:
> I have the following code querying MS SQL Server
>
> $query = "SELECT * FROM mytable";
> $res = mssql_query($query);
> $nr = mssql_num_rows($res);
> for ($i=0; $i<$nr; $i++)
> {
> $a = mssql_fetch_array($res);
> $query = "SELECT * FROM anothertable WHERE id=".$a['anotherID'];
> $res1 = mssql_query($query);
> $anr = mssql_num_rows($res1);
> ...
> }
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
