Storing part queries with PHP

[Anon]

Hi,

I have come across a query which is just too difficult to do at once so I have decided to split it up into several simpler queries.

I want to do the first query (3 variables come from html form), store the results,

then, do the second query based on the stored reults, then store these results,

then do the third etc etc

until I get the answer.

Is this possible? The query is only a select statement (no insert/delete/update).

Thanks!

[[deleted]]

Everything is possible, but the point is, how diffucult do you want to make things.

You'll need databas tables to hold your "stored results" which means you can only run one of those "complicated queries" at a time, or they will overwrite eachothers stored results.

Did you have a good look at the SQL language? sometimes you can find neat tricks to do things you didn't think were possible..

[terje-s]

I have yet to see a query that is too complicated for SQL to handle ;-) But, the real question is; store the temporary data in a table? Wouldn't one array per query do the job? e.g.:

$resultArray1 = array();
$resultArray2 = array();

$result1 = mysql_query(..);
$result2 = mysql_query(..);

while ($resultArray1[] = mysql_fetch_array(..));

.. and the same for result2..

Then you would have the entire results stored in one array each, and you can combine and do basically whatever you want to them (including match of e.g. userids for fields etc).. and then store the final result.. ?

or am i just too tired to think?

[[deleted]]

That is also a possibility, you can store all temp-results in an array. It depends entirely on what you want to do with the data.

If you want to do an insert for every result from a select, then using an array would be good.
But if you want to join using 'stored data' things become very much more difficult using array's.

If your queries are just selects with data from other selects, you could also choose to open the first query,
fetch the first result, use that to start a second query,
fetch the first result from that, and use it to start the thrid query.
When the third query is finished, you can move to the next result of the second query, use it, etc untill query 2 is finished, then move to the next result of the first query.

As you can see that can give "tons" of queries.