Re: [PHP] Nested queries don't work

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_q

RE: [PHP] Nested queries don't work

Rich Fox on Wednesday, October 15, 2003 12:37 PM said: > This does NOT work! It seems that the 2nd query steps on the results > of the first one! Can someone verify this effect? Seeing that you're using different result variables I would think that it should work al

[PHP] Nested queries don't work

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($quer