[Resolved] [Resolved] Searching within results of previous search

[dleone]

I have a page that searches a database for key words and then return a list of items of that search. I'd like to then provide an option to search those results only. Any ideas on how to implement this as the results are simply output to the page from after being placed in an array, not stored in any table. Any thoughts?

[insane]

Perhaps you could store the previous DB-query String (in a session) and when the "search in results"-option is called connect the previous query with the new.

$previous_query = "SELECT * FROM table WHERE (name LIKE %bla% OR firstname LIKE %bla%)";

$new_query = $previous_query .= " AND (name LIKE %bla2% OR firstname LIKE %bla2%)";

[dleone]

Ahhh. Thanks. That works perfectly.