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