RE: [PHP-DB] Linked tables and fields in a form

use this on the first SELECT : <select name="SELECT" onChange="window.navigate('<?=$PHP_SELF ?>?choice='+this.value)"> when u choose an option the page will be refreshed and the $choice will be available thru HTTP_GET_VARS["choice"] all u have to do is check if the var exists and execute the second MySql SELECT acording to the $choice -----Mensagem original----- De: Peter Goggin [mailto:pgoggin@smartchat.net.au] Enviada: terça-feira, 2 de Julho de 2002 2:00 Para: php-db@lists.php.net Assunto: [PHP-DB] Linked tables and fields in a form I have two related tables. The first has about 12 records, each of which is related to about 12 records in the second table. I want to have two interconnectedt dropdown list fields. The fist is used to select from the first table and when the value has been selected, use it to determine the contents of the second drop down list. Obviously I can do this by having interrelated pages where the value from the first fiels is carried to the second page and used to populate the second drop down list. Is there any way of doing this so within a single page? Regards Peter Goggin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php