# Connect To The Database
my $dbh = DBI->connect("DBI:mysql:masslottery_db", "root", "system1");
 die "Connect to masslottery_db failed: " . DBI->errstr() unless $dbh;
 print "connect to masslottery_db successful!\n";
 
#Prepare The Query To Get Data From Table Dailymf
#$dbh Is Called The Database Handler
my $sth = $dbh->prepare("Select dailymf_drawdate,dailymf_number FROM dailymf") 
                 or die "Prepare For Dailymf Failed: " . $dbh->errstr();

#Execute The Query
#$sth Is Called The State Handler
$sth->execute()
       or die "Execute For Dailymf Failed: " . $sth->errstr();

#Read (loop) Each Row (record) and Print It
while (($dailymf_drawdate, $dailymf_number) = $sth->fetchrow()) {
        print "$dailymf_drawdate : $dailymf_number\n";
		}