> -----Original Message----- > From: Micah Gersten [mailto:micah@xxxxxxxxxxx] > Sent: Thursday, July 31, 2008 1:59 PM > To: PHP General list > Subject: Re: Dynamic Select Lists - 1st Selection Effects 2nd! > > What I usually do is default to the most common country and show the > associated states. > You can change the states if they change the country. > > Thank you, > Micah Gersten > onShore Networks > Internal Developer > http://www.onshore.com > > > > Andrew Ballard wrote: > > On Thu, Jul 31, 2008 at 12:40 PM, Rahul S. Johari > > <sleepwalker@xxxxxxxxxxxxxxxx> wrote: > > > >> Ave, > >> > >> What I have is two Select (Drop-Down) lists (State & County) and I'm > >> populating them from a mySQL table. What I want is when the user > selects the > >> State from the State List, the County List should only pull out > counties > >> associated with that State. > >> > > [snip] > > > > This is a usability issue rather than a code issue, but wouldn't you > > want that to be the other way around? (ie, select the country from a > > list and it populates the state list with > > states/provinces/territories/adminstrative disticts/etc. that belong > > to that country?) I know the order is "backward" from how one > > typically writes an address on paper, but otherwise your state list > > will be HUGE and often your country list would only have one value > > after the user selects a state. *cough* ...pretty sure he wrote "county", guys. ;) Todd Boyd Web Programmer