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.

> -----Original Message-----
> From: Stiphane RIVEZ [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 26, 2003 2:12 PM
> Subject: [PHP-DB] 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

Reply via email to