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