#!/usr/bin/perl -w
 use Net::FTP;
 use DBI;
 
 $dbh = DBI->connect('dbi:mysql:database','user','pass')
 or die "Connection Error: $DBI::errstr\n";
 $sql = "select concat_ws(',' , TIME_FORMAT(NZST,'%h:%i')  ,DATE_FORMAT(NZST,'%d/%m/%y'),t2,'',wdchill,rh,dp,bp,'',wdspd,ROUND(wddeg),rn,'','','','',wdgst,'c|kmh|mb|mm') FROM tbl_owwdata ORDER BY wx_idx DESC LIMIT 1";
 $sth = $dbh->prepare($sql);
 $sth->execute
 or die "SQL Error: $DBI::errstr\n";
 while (@row = $sth->fetchrow_array) {
 open (MYFILE, '>WL_stickertags.txt');
 print MYFILE "@row\n";
 close (MYFILE); 
 }
 

    $ftp = Net::FTP->new("some.where.com", Debug => 0)
      or die "Cannot connect to Simplehost: $@";

    $ftp->login("******",'*******')
      or die "Cannot login ", $ftp->message;

    $ftp->cwd("/a.b.c/folder")
      or die "Cannot change working directory ", $ftp->message;

    $ftp->put("WL_stickertags.txt")
      or die "put failed ", $ftp->message;

    $ftp->quit;
 
 exit 0