如何为我的应用程序创建索引数据库

i have an application like this. enter image description here

i was reading this tutorial : http://use-the-index-luke.com/sql/where-clause/the-equals-operator/concatenated-keys and according to case in that blog, i'm imagine to my application ( CMIIW ) so i need to create indexing like :

  1. index 1 - country (for searching country only)
  2. index 2 - country - district ( for searching country and district)
  3. index 3 - country - district - city
  4. index 4 - price
  5. index 5 - country - price ( for searching country and price )
  6. .....
  7. ....

are that list index above i created correct ? because I'm not sure if i am doing it right, please correct me... thanks in advance and best regards.

My Friend You Can Use A File With Different $_GET values Like :

check.php?method=country&country=SOMETHING user SENDs

8-)