查询查询 - MySQL和PHP(Query a Query - MySQL and PHP)

 我最近试图做一个项目*，这让我问这个问题。 虽然从那以后我找到了另一种解决方案，但我仍然很好奇，如果我想象的那样，无论如何都是可能的。 
 
 基本上，我想知道是否有任何方式在php中对MySQL查询结果执行MySQL查询。 例如： 
 
$result = mysql_query("SELECT * FROM foo WHERE bar=".$barValue);
 
 然后，能够对$result执行多个查询： 
 
$newResult = mysql_query("SELECT * FROM $result WHERE otherBar=".$barValue);
 
 要么 
 
$otherNewResult = mysql_query("SELECT * FROM $result WHERE otherOtherBar=".$barValue." ORDER BY foobar ASC");
 
 等等等等... 
 
 我意识到我可以使用我的新WHERE语句和ORDER BY s附加原始查询，但这会导致我不必要地查询数据库并且它阻止我编写更多面向对象的代码（因为我无法传递结果是查询，而是必须在每个函数中重新查询数据库...） 
 
 任何建议，代码，框架或ramblings都赞赏。 
 
 *顺便说一句，我的项目不得不为某些年龄组中出生的人查询大型人员数据库，然后查询这些年龄组的不同人口统计数据。 
 
 编辑 
 
 不，编写自定义函数来查询数据库不值得它给我的面向对象（和可修改性） 

I was recently trying to do a project*, which caused me to ask this question. Although since then I've found an alternative solution, I am still curious if what I envisioned doing is, in any way, possible.
 
Essentially, I am wondering if there is anyway to perform a MySQL query on a MySQL query result in php. For example:
 
$result = mysql_query("SELECT * FROM foo WHERE bar=".$barValue);
 
AND THEN, be able to perform multiple queries on $result:
 
$newResult = mysql_query("SELECT * FROM $result WHERE otherBar=".$barValue);
 
OR
 
$otherNewResult = mysql_query("SELECT * FROM $result WHERE otherOtherBar=".$barValue." ORDER BY foobar ASC");
 
AND so on and so forth...
 
I realize that I could append the original query with my new WHERE statements and ORDER BYs, but that causes my to query the database unnecessarily and it prevents me from writing more objected oriented code (because I can't pass around a result to be queried, but rather have to requery the database in every function...)
 
Any advice, pieces of code, frameworks, or ramblings appreciated.
 
*BTW, my project was having to query a large database of people for people born in certain age groups and then query those age groups for different demographics.
 
Edit
 
No, writing a custom function to query the database is not worth the object-orientation (and modifiability) it would give me

原文：https://stackoverflow.com/questions/6977408