my $x = $main->{settings}{x}; my $sql; if($x == 1) { $sql = qq{select * from $main->{settings}{wbbnr}_sessions where hash = '$sid'}; } if($x == 2) { $sql = qq{select * from $main->{settings}{wbbnr}_sessions where sessionhash = '$sid'}; } my $sth = $dbh->prepare($sql);