populate multiple drop down from same database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
dt22
Forum Commoner
Posts: 32
Joined: Sat Oct 10, 2009 2:53 am

populate multiple drop down from same database

Post by dt22 »

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.
User avatar
social_experiment
DevNet Master
Posts: 2793
Joined: Sun Feb 15, 2009 11:08 am
Location: .za

Re: populate multiple drop down from same database

Post by social_experiment »

One database (or maybe one table?) isn't as big a stumble block as you think. Are you using AJAX with this?
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
Post Reply