the layout of my db my $host = "localhost"; my $usr = "root"; my $pwd = "hell"; my $dbname = "helldb"; my $dbh = DBI->connect("DBI:mysql:$dbname:$host", $usr, $pwd, { RaiseError => 1, }) or die $DBI::errstr; my $select = $dbh->prepare("SELECT something FROM info"); $select->execute(); my $info = $select->fetchrow();