call the appropriate and correct database

Abdullah Bahar <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <[email protected]>
How do I call first database table as follows :

id | country | province | distric | cost
------------------------------------------------
1 | USA | Alanama | distrik | 20
2 | USA | Alabama | distrik2 | 22
3 | USA | Alabama | distrik3 | 22
4 | France | Paris | disrik4 | 30

now I use 3 kinds of calls to select a form below. I am using Jquery 
chain (no problem) :

1. SELECT country from table GROUP BY country ORDER BY country ASC
<select>
<option value="country" class="">Country</option>
</select>

2. SELECT province from table GROUP BY province ORDER BY province ASC
<select>
<option value="province" class="Country">Province</option>
</select>

3. SELECT distric from table GROUP BY distric ORDER BY distric ASC
<select>
<option value="distric" class="province">distric</option>
</select>

What I want to call the database whether it is appropriate ? or is there 
another way that is more simple .
Loading page is very long .
Kindly enlighten


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.