use DBI;  
use CGI; 
$dbh = DBI->connect('dbi:mysql:Database','root','password')
or die "Connection Error: $DBI::errstr\n";

#my $sth = $dbh->prepare("insert into logintbl(username, password) values('jones2010','password') "); 
#my $sth2 = $dbh->prepare("insert into studenttbl(fname,lname,grade,DOB,email,tel_no,membertype,username) VALUES ('jamie','batty','7thkyu','1988/07/21','battydave&#64hotmail.com','012345234543','monthly pay','jones2010')");
#$sth->execute();
#$dbh->disconnect;

$dbh->{AutoCommit} = 0; # disable auto-commit
$dbh->do ("insert into logintbl(username, password) values('jones2100','password')");
$dbh->do ("insert into studenttbl(fname,lname,grade,DOB,email,tel_no,membertype,username) VALUES ('jamie','batty','7thkyu','1988/07/21','battydave&#64hotmail.com','01234523454','monthly pay','jones2010')");
$dbh->commit();