Can php query the results from a previous query? Can php query the results from a previous query? mysql mysql

Can php query the results from a previous query?


There is no MySQL function like this for PHP, however there is a more advanced substitute for it.

Edit: For those of you who don't know what a query of queries is, it's exactly this and there's a purpose some people do it like this. Using an AND operator is ****NOT**** the same thing! If I want results where username='animuson' for one part of my script and then want all the results out of that query where status='1', it is not logical for me to run another query using an AND operator, it is much more logical to loop through the previous results in PHP. Stop upvoting things without reading the comments on why they weren't upvoted in the first place, that's just lazy. If you don't have a clue what's being talked about, you shouldn't be upvoting or downvoting in the first place.


Well, you may want to do this without touching the db:

while($t = mysql_fetch_array($rs1)){    if($t[name] == 'trout'){         echo 'This is the one we\'re looking for!';         break;    }}


In PHP, it would be terribly inefficient. You would have to loop through each row and check that its name was trout. However, is there any reason you can't do

SELECT * FROM `animals` WHERE `type` = 'fish' AND `name` = 'trout'

in SQL? It would be much, much faster.