Showing Specific Rows at top

• • Reply

  13 years ago

  by alohamora

  Aloha Mora

  , Singapore

  Joined 15 years ago

  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

  Report abuse
• • Reply

  13 years ago

  by joe90

  J Alan

  , United Kingdom

  Joined 15 years ago

  Do you already have a list of IP Addresses with their location as a separate table?

  Joe 

  [for instance: http://www.private.org.il/IP2geo.html]
   

  Report abuse