Hi Friends,
I am working on a shopping search engine application. I want to make the search experience area specific, like when user browse my application finds the CityName of the user from its IP address. now I want to show the products/stores in that city at the top in the search results.
eg if user search for skirts and he is sitting in NY while browsing then skirts/ stores selling skirts in NY show come at the top of the result page.
My StoteMaster table is very simple.
StoreID, StoreName, toreAddress, ProductKeywords, SCountry, SZipCode, Long, Lat, SWebiste, SEmail
Plz Help me in this to make the sql query.
Thanks
Aloha
Enter your message below
Sign in or Join us (it's free).