use DBI qw(:sql_types);
$sth->bind_param(1, $offset, SQL_INTEGER);