Web lists-archives.com

call the appropriate and correct database




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