#!/usr/bin/perl use strict; use CGI ':standard'; use DBI; my $q= CGI->new(); print $q->header(), $q->start_html(); my $dbh = DBI->connect('DBI:mysql:mirnas', 'root', 'bi0u90ee') or die "Couldn't open database: $DBI::errstr; stopped"; # Getting all the column names and creating checkboxes for them my $table = '07_11_09'; my $sth = $dbh->prepare("SELECT * FROM $table where 1=0 "); $sth->execute; my @cols = @{$sth->{NAME}}; # or NAME_lc if needed #print "@cols\n"; $sth->finish; my @responce; my $tissues; @responce = param('fields_to_search'); $tissues = $#responce +1; print " You have selected the following $tissues tissues"; print "", end_html;