I have 2 text boxes one is for resource and another one is for location.
As of now what i did was i create stored procedure for displaying search results. My problem is while giving resource it s fetching the corresponding resource but also taking other resource that match with location
for example if i searched for saloon in India it is displaying a the result which is in the location( India ) and also display hospital,school etc..
assume that:
textbox 1: Saloon textbox 2: India
if i give like this my search results coming
search result
Resource : Naturals - India's No: 1
Location : India
Resource : Apollo Hospitals
Resource : Sahyadri School
how to solve this ??
stored procedure is