Query of existing query data in PHP

[markwilliamson2001]

I am trying to create a new query based on existing query data that I have created in PHP.

Is this possible? I remember doing it really easily in ColdFusion and ASP, but cannot figure out how to do it in PHP yet...


Thanks,
Mark

[CESIL]

I don't fully understand what you mean by this...can you give more detail about what the end result should be?

I am guessing that in ASP you were querying an existing recordset...is that right?

Mark

[markwilliamson2001]

Yes that is correct, a previous recordset has already been created, the results of which I would like to filter out again, using a further recordset.

[contink]

Yes that is correct, a previous recordset has already been created, the results of which I would like to filter out again, using a further recordset.

I'd love to help but I'm a PHP coder and never touched ASP in my life... so I've no idea what you're referring to here.

Could you give an idiots guide to exactly what you mean by your "recordset", what form it's stored in, where, etc... and then someone may be able to help.

[ZeroHour]

ASP does allow this using datasets.
PHP though has another way, your result is an array usually. Look for ways to search the array and you may find something that does something similar. I dont think php has a full equivalent to dataset but I am not fully up on php5's new features.
What query would you need to run on the result?

[markwilliamson2001]

I have actually sorted out a solution to this problem, although it is a little basic...

Thanks for the help anyway guys.

Mark