example code for dynamically generated drop down boxes?

hi all,
can someone guide me on how to do the following?

i will have a drop down box, with the entries 'Manchester, London,
Birmingham' etc.

When you choose Manchester, it may depending on sub entries, pop up another
drop down box with sub entries such as 'Man Utd., Man City' etc. If there
are no sub entries, no new drop down is shown.

This can lead to another drop down... E.g. London --> North --> Tottenham
Hotspur

etc.

When submit is clicked, this entry is added to a MySQL database,

any ideas?
thanks

abc wrote:

> hi all,
> can someone guide me on how to do the following?
>
> i will have a drop down box, with the entries 'Manchester, London,
> Birmingham' etc.
>
> When you choose Manchester, it may depending on sub entries, pop up
> another drop down box with sub entries such as 'Man Utd., Man City' etc.
> If there are no sub entries, no new drop down is shown.
>
> This can lead to another drop down... E.g. London --> North --> Tottenham
> Hotspur
>
> etc.
>
> When submit is clicked, this entry is added to a MySQL database,
>
> any ideas?
> thanks

You are asking for somebody to do programming for you. Hire somebody if you
cant do it yourself.


To give you some idea, I generate the "year" dropdown box in
http://www.ipo-australia/scgi-bin/be...eport=advanced
using Perl & mysql, as follows:

sub select_year {
my $all = @{getrec('select count(*) kount from ipo where
visible="Y"')}->[0]->{kount};
print<<EOF;
<table>
<tr><td class=small><b> Year - multiple selection</b></td></tr>
<tr><td>
<SELECT size="10" name="year" multiple>
@{[option('year','all',"All ($all)")]}
EOF
print option('year',"$_->{year_kount}","$_->{year_kount}
($_->{kount})") for @{getrec('select year(ipo_dt) year_kount, count(*)
kount from ipo where visible="Y" and ipo_dt>19900101 group by
year(ipo_dt)')};
print<<EOF;
</SELECT>
</tr></td></table>
EOF
}


gtoomey