If I understand your problem correctly, it sounds like you need to get all of the values for the two select objects (which you can do with PHP, of course) then use JavaScript to handle the CLIENT SIDE update process between the two objects. If that sounds like what you're looking for, you can find numerous tutorials and code samples on the web. Just search for "javascript" on google and you should find a number of sites with script repositories. Pick a site and look to see what they have to satisfy your requirements. Hope that helps. Rich > -----Original Message----- > From: Stiphane RIVEZ [mailto:srivez@moensservices.be] > Sent: Friday, September 26, 2003 2:12 PM > To: php-db@lists.php.net; doc-fr@lists.php.net > Subject: Selection problem > > > Hello, > > I'm novice in php and mysql utilization.... so... > Here is my problem: > I have a form with some fields (for example, 2: field1 and field2) > My mysql database contains for example 1 table (named for > example SQLTABLE) > with 3 fields: ID (auto_increment), AA, BB. > On my form, field1 is represented in HTML by a <SELECT > SIZE="1"...> and > returns values of AA in selected in SQLTABLE. > I want when I choose a value with the selection menu in > field1 of the form, > that the BB corresponding value of the selected AA > automatically appears in > field2 of my form without submitting my page, without loosing > informations > already encoded in the page. (An application could be a > customer subsciption > form, where you have to enter your name, adress, ZIP, town, for a > determinated country... and you can choose the zip code in a > selection menu > and automatically the corresponding town is shown next to it before > subitting the form...) > > I suppose that a lot of people can help me.... > > Thanks... > > Stephane, Belgium > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
