I'm trying to make a cgi page that has 2 dropdown menus: The first one is here already (using entry1 and entry2. I want a second dropdown menu that queries my database (the table names are entry1 and entry2, grabs the columns from the database, puts them in a second drop-down menu. When this second one is created, I wish for the user to be able to select one and then have it grab the data sorted by that category. I know the sql statements, but I'm trying to get to that point.
use CGI qw(:standard);
start_html('New User Page');
print '<B>Please select the table from the drop down menu.</B><BR><BR>';
print "<select name=\"tableName\">";
print "<option value=". "entry1" ."> "."entry1";
print "<option value=". "entry2" ."> "."entry2"." </select>";