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
