### DECLARE VARIABLES
my $uname = $FORM{'req_username'}; 
my $pword = $FORM{'req_password'};


### DEFINE A MySQL QUERY
my $sql = qq{SELECT * FROM $tablename 
				WHERE
				username = '$uname' 
				AND
				password = '$pword'};
my $sth = $dbh->prepare($sql);

### EXECUTE THE QUERY
$sth->execute();

### TEST THE USERNAME AND PASSWORD
if(username ne '$uname' &&  password ne '$pword') # this does not work