[PHP-WIN] nested resultsets

[Sandeep Murphy]

Hi,

How do I handle nested resultsets??

like i hv 

while(  $row = $resultSet->fetchRow(DB_FETCHMODE_ASSOC) ) 
{
        echo "CODE = ".$row["code"]."  NAME =  ".$row["name"]."<br>";

        $policySQL = "SELECT policy_code from profile_policy where profile_code 
=".$row["code"];

         $result = $dbSP->query($policySQL); 
        
                while($rows = $result->fetchRow(DB_FETCHMODE_ASSOC) ) 
                {

                        // now IF I try to echo the result stored in the array $rows, 
nothing happens. why???
                }
}

thnx,
sands


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