my $sql = 'INSERT INTO test_table VALUES (?,?,?,?,?,?)';
		my $sth = $dbh->prepare($sql);		
		$sth->bind_param(1, 'test_env');
		$sth->bind_param(2, $partner);
		$sth->bind_param(3, $id);
		$sth->bind_param(4, $filename);
		$sth->bind_param(5, "$date $time");
		$sth->bind_param(6, $line_count);
		$sth->execute();

##</code><code>##

        my $sql = <<EOSQL;

INSERT INTO test_table 
VALUES (?,?,?,?,?,?)

EOSQL
        my $sth = $dbh->prepare($sql);		
        $sth->execute('test_env', 
                      $partner,
                      $id, 
                      $filename, 
                      "$date $time", 
                      $line_count,
                      );