populate multiple drop down from same database
Posted: Wed Apr 13, 2011 7:00 am
Hi all,
Am again in a trouble with the php.
I had a database which consist of a lots of fields. For example there are three field like : name, age, location etc etc
what I want to do is that: there will be two drop down box which will display the DISTINCT location list, and when anyone select any particular location the name of people belongs to the location must listed on the same page within an another drop down box. so that any person from the list can pick to send email.
I know how to do it if it is in two different table. but right now i have a single database.
Can anyone guide me. Pls...Thanks in advance.
Am again in a trouble with the php.
I had a database which consist of a lots of fields. For example there are three field like : name, age, location etc etc
what I want to do is that: there will be two drop down box which will display the DISTINCT location list, and when anyone select any particular location the name of people belongs to the location must listed on the same page within an another drop down box. so that any person from the list can pick to send email.
I know how to do it if it is in two different table. but right now i have a single database.
Can anyone guide me. Pls...Thanks in advance.