my $sth = $dbh->prepare("SELECT * FROM tickets ORDER BY ticket_id"); $sth->execute(); my $first; my $i = 0; while (my $record = $sth->fetch()) { if ($i == 0) { $first = $record; } blahh... blahh... $i++ }