Searching within a search result

[coolphpdude]

Hi,

 

quick question for you... is it possible to search within a search result (refine an existing search).

 

If i done an original search ($keyword as the searched word) e.g. $search = mysql_query("SELECT * FROM holidays WHERE holiday_hotel = $keyword")

 

is it then possible on the next page to have another search box where the user could type in another keyword to search for?

 

so for example, the user has searched for 'leazes hotel' and returned 30 results from various different countries around the world, could the user then search for 'france' as the location within that existing search result??

 

Thanks

[unsider]

Yes. I'm pretty sure it's possible. Where you place your code is the trick.

[coolphpdude]

what i actually want the user to do is go see the original results and then refine the results

[coolphpdude]

Any idea how then?

[coolphpdude]

can it be done or could someone point me in the right direction of something that could help me?

[soycharliente]

Create a form that has hidden inputs for what they search the first time. All the user would see if a button that says refine search and all the previous values from the form would be submitted to a page. That page would just populate the search form again with what is posted.

[coolphpdude]

ahh so carry forward the original search keyword and then take in the refined search as '$refine' then resubmit the search as

select * from holidays where holiday_hotel = $keyword AND holiday_location = $refine??

[soycharliente]

If you want both variables to come into play, sounds like a plan to me.