my $sth = $dbh->prepare('SELECT * FROM applicant WHERE date_col = ? ORDER BY job_position LIMIT ?,10'); 
     $sth->bind_param(2, $limit, DBI::SQL_INTEGER);
     $sth->execute($date,$limit) or die $sth->errstr;