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
the two objects.
If that sounds like what you're looking for, you can find numerous tutorials
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
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-DB] Selection problem
> 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
> 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....
> 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