List of records by joining three tables( Country , State, City )
- Tutorial Three Drop down
- Admin
- DEMO: Three Drop down
- Show All
- Add City
- Add State
- Add Country
CODE | COUNTRY | Del | STATE _ID | STATE | Del | CITY_ID | CITY | Del |
---|
IND | INDIA | | 1 | Maharashtra |
|
1 | Mumbai (Bombay) |
|
IND | INDIA | | 1 | Maharashtra |
|
2 | Nagpur |
|
IND | INDIA | | 2 | Delhi |
|
3 | Delhi |
|
IND | INDIA | | 3 | West Bengali |
|
4 | Calcutta [Kolkata] |
|
IND | INDIA | | 4 | Tamil Nadu |
|
5 | Chennai (Madras) |
|
IND | INDIA | | 5 | Andhra Pradesh |
|
6 | Hyderabad |
|
IND | INDIA | | 6 | Gujarat |
|
7 | Ahmedabad |
|
IND | INDIA | | 7 | Karnataka |
|
8 | Bangalore |
|
IND | INDIA | | 8 | Uttar Pradesh |
|
9 | Kanpur |
|
IND | INDIA | | 8 | Uttar Pradesh |
|
10 | Lucknow |
|
IND | INDIA | | 9 | Maharashtra |
|
11 | Mumbai (Bombay) |
|
IND | INDIA | | 9 | Maharashtra |
|
12 | Nagpur |
|
AFG | AFGHANISTAN | | 12 | Qandahar |
|
16 | Qandahar |
|
AFG | AFGHANISTAN | | 13 | Herat |
|
17 | Herat |
|
AFG | AFGHANISTAN | | 14 | Balkh |
|
18 | Mazar-e-Sharif |
|
USA | USA | | 15 | New York |
|
19 | New York |
|
USA | USA | | 16 | California |
|
20 | Los Angeles |
|
USA | USA | | 16 | California |
|
21 | San Diego |
|
USA | USA | | 17 | Illinois |
|
22 | Chicago |
|
USA | USA | | 18 | Texas |
|
23 | Houston |
|
USA | USA | | 18 | Texas |
|
24 | Dallas |
|
USA | USA | | 18 | Texas |
|
25 | San Antonio |
|
USA | USA | | 19 | Pennsylvania |
|
26 | Philadelphia |
|
USA | USA | | 20 | Arizona |
|
27 | Phoenix |
|
USA | USA | | 21 | California |
|
28 | Los Angeles |
|
USA | USA | | 21 | California |
|
29 | San Diego |
|
USA | USA | | 24 | Michigan |
|
36 | Detroit |
|
CAN | CANADA | | 25 | Québec |
|
37 | Montréal |
|
CAN | CANADA | | 26 | Alberta |
|
38 | Calgary |
|
CAN | CANADA | | 26 | Alberta |
|
39 | Edmonton |
|
CAN | CANADA | | 27 | Ontario |
|
40 | Toronto |
|
CAN | CANADA | | 27 | Ontario |
|
41 | North York |
|
CAN | CANADA | | 27 | Ontario |
|
42 | Mississauga |
|
CAN | CANADA | | 27 | Ontario |
|
43 | Scarborough |
|
CAN | CANADA | | 27 | Ontario |
|
44 | Etobicoke |
|
CAN | CANADA | | 29 | Manitoba |
|
50 | Winnipeg |
|
CAN | CANADA | | 33 | British Columbia |
|
63 | Vancouver |
|
GBR | GREAT BRITAIN | | 35 | England |
|
69 | London |
|
GBR | GREAT BRITAIN | | 35 | England |
|
70 | Birmingham |
|
GBR | GREAT BRITAIN | | 35 | England |
|
71 | Liverpool |
|
GBR | GREAT BRITAIN | | 35 | England |
|
72 | Sheffield |
|
GBR | GREAT BRITAIN | | 35 | England |
|
73 | Manchester |
|
GBR | GREAT BRITAIN | | 35 | England |
|
74 | Leeds |
|
GBR | GREAT BRITAIN | | 35 | England |
|
75 | Bristol |
|
GBR | GREAT BRITAIN | | 37 | Scotland |
|
83 | Glasgow |
|
GBR | GREAT BRITAIN | | 37 | Scotland |
|
84 | Edinburgh |
|
GBR | GREAT BRITAIN | | 44 | Wales |
|
122 | Cardiff |
|
AUS | AUSTRALIA | | 46 | Victoria |
|
127 | Melbourne |
|
AUS | AUSTRALIA | | 48 | West Australia |
|
130 | Perth |
|
AUS | AUSTRALIA | | 49 | South Australia |
|
131 | Adelaide |
|
AUS | AUSTRALIA | | 50 | Capital Region |
|
132 | Canberra |
|
AUS | AUSTRALIA | | 51 | Queensland |
|
133 | Brisbane |
|
AUS | AUSTRALIA | | 51 | Queensland |
|
134 | Gold Coast |
|