in reply to Drop Down Selection From Database
Seeing as your using
you must be using the CGI module, so you need to use$query->textfield(-name=>'Company_Name',-size=>20);
$query->popup_menu(-name=>'Company_Name',-values=>\@first_entries);
values will accept an anonymous array
a pointer to an array as above['company1','company2']
and will be ordered as presented. However you can otherwise specify which element should be presented by default@first_entries=('company1','company2');
finally you could (for example) want the script to call the companies by url while the dropdown box displays the company_name (or more likely to use id fields) in which case-default=>'company1'
@values=('URL1','URL2','URL3'); %labels=('URL1'=>'company1','URL2'=>'company2','URL3'=>'company3'); print $query->popup_menu(-name=>'Company_Name', -values=>\@values,-labels=>\%labels,-default=>'URL2');
As for getting the data in there....there's more than one way to do it :-)
|
|---|