From: Sasha Pachev
Date: March 26 1999 12:42pm
Subject: Re: Mysql/Perl Question?
List-Archive: http://lists.mysql.com/mysql/1013
Message-Id: <36FB80AA.A29DB00D@direct1.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Douglas Brantz wrote:
> 
> This is probably not possible, but I would like to create a web form
> that would give a person the ability to choose whatever field they want
> with five drop down menus.
> and then get the results from the database, something like the ODBC
> query.
> 
> example-Name="FIRST" the choices could be fields from the table such as
> <OPTION VALUE="dept">Department
> </SELECT>
> 

This is not a difficult thing to do actually. Just write some logic that
will construct the query string from the user input. Something like
this:

cgiparse();

@fields = ();

push(@fiels, $env{field_1) if(env{field_1));
push(@fiels, $env{field_2) if(env{field_2));
...

$query = "select ".join(',',@fields)." from the_table";

-- 
Sasha Pachev
http://www.sashanet.com