Just to put my 2cents in, you might want to try jQuery if you're going to go down the AJAX road. James. On Wed, Jul 18, 2012 at 1:59 AM, Ramiro Barrantes < ramiro@xxxxxxxxxxxxxxxxxxxxx> wrote: > Thanks to everyone for their help, AJAX is the way to go. > > Daevid, it's interesting you welcome me to the year 2000, I actually > graduated from CS in 1999 and haven't really done much more than simple > web-programming since (have done scientific programming instead), so I am > definitely behind the times!!! > > ________________________________________ > From: Jen Rasmussen [jen@xxxxxxxxxxxxxxxx] > Sent: Monday, July 16, 2012 4:19 PM > To: Ramiro Barrantes; php-general@xxxxxxxxxxxxx > Subject: RE: Creating drop-down menus > > -----Original Message----- > From: Ramiro Barrantes [mailto:ramiro@xxxxxxxxxxxxxxxxxxxxx] > Sent: Monday, July 16, 2012 3:17 PM > To: php-general@xxxxxxxxxxxxx > Subject: Creating drop-down menus > > Hello, > > I am making an application using PHP/Javascript/mysql and had a question. > > Sometimes I need to use javascript to fill a drop down box based on the > value of a previous drop down box. However, the information to fill the > latter is stored in mysql and can be a lot, what I have been doing is that, > using PHP, I create hidden fields with all the possible information that > might be needed to fill the second drop down. > > For example, the user chooses a bank from a drop down, and then a list of > clients is displayed on the following drop down. I use PHP to read all > clients from all the banks and put that as hidden fields on the html page. > It is very cumbersome. > > I do not want to read the database (which changes dynamically) from > javascript directly due to confidentiality and because a lot of care has > been taken to create the appropriate queries with checks and protect > misuse > of the information using PHP. > > My questions are: > 1) Do people just normally use hidden fields to store possible information > to fill the drop downs? > 2) any suggestions? > > Thanks in advance, > Ramiro > > ** > > You could also store the information as a session variable. > > Jen > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
