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: 174

Filed under:
|
|
|

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

Related posts about php

Related posts about mysql