Hi,
i am doing a webpage which can access a database. The user enters their question into a web form.
I have a very complicated query. Is it possible to split this up(especially as mysql cant do nested selects), store the results somewhere, then use these in another part of the query?
Would I need to store these \'intermediate\' query results in a new table or could PHP store them in some kind of array?
THanks
i am doing a webpage which can access a database. The user enters their question into a web form.
I have a very complicated query. Is it possible to split this up(especially as mysql cant do nested selects), store the results somewhere, then use these in another part of the query?
Would I need to store these \'intermediate\' query results in a new table or could PHP store them in some kind of array?
THanks