[PHP] Nested queries don't work

[Rich Fox]

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);
    ...
}

This does NOT work! It seems that the 2nd query steps on the results of the
first one! Can someone verify this effect? I am 99.999% sure this is what's
happening. Who is the bonehead responsible for not implementing this for MS
SQL Server?

Thanks

Rich

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php