Can php query the results from a previous query?
        Posted  
        
            by eaolson
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by eaolson
        
        
        
        Published on 2010-05-09T17:00:48Z
        Indexed on 
            2010/05/09
            17:08 UTC
        
        
        Read the original article
        Hit count: 217
        
In some languages (ColdFusion comes to mind), you can run a query on the result set from a previous query. Is it possible to do something like that in php (with MySQL as the database)?
I sort of want to do:
$rs1 = do_query( "SELECT * FROM animals WHERE type = 'fish'" );
$rs2 = do_query( "SELECT * FROM rs1 WHERE name = 'trout'" );
© Stack Overflow or respective owner