To search within search results.

[zeroxmxi]

[FONT="Trebuchet MS"]Is there a good and efficient way of searching within previously searched records using PHP/MySql? I tried searching on google with several keywords like nested search, search within results, recursive search with PHP and MySql, haven't got a clue so far yet. But I thought it might be just storing previously queried sql statements and to a select on it each time the search button is called? Any ideas?[/FONT]

[paulnaj]

Hi,

With later versions of mysql (see manual) you can do something like ...

SELECT
FROM (SELECT FROM ... etc)

... which is 'nested'.

But that might not be the sort of thing you want.

You may need to just add another 'WHERE' clause ( using 'AND') to your existing SQL to refine the search.

You'll have to be a bit more specific, I think ... show us an example of what you mean (an sql query).

P. 🙂

[bpat1434]

You could do a search, then write those results to a permanent temp table. Then perform a query on that table later. Only problem is the amount of space you have, and how long of a life the table has. You could also use one permanent search table, and return results and link results by a search id, and save searches that way.