thanks for your reply.
The more specific filtering supposed to be performed upon the query results on the server side (not client side)
I still have no idea if there is any way to maintain the query results inside active session though the php scripts already ended.
What is the only thing in my thought right now is to extend the where clause (re-starting the query from the very beginning again), which will look something like this:
select * from prodtable where ProdCategoryID=x AND price>$$$ AND price<$$$
In a simple case, the above query will be fine. However my concern is if the query will get more complex, then there will be a lot of "AND" in the where clause.
My point is, if there is any way to maintain the existing query results, and to run filtering upon this existing results instead of getting the sql server to perform query from the very beginning again.