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
