my $sth = $dbh->prepare( 'SELECT Questions, Answers from QA where ID = ?' ); $sth->execute($id); # put your bind_columns and fetches in # and if you really want then you can do $sth->finish; $sth->execute($id2); # and get another set of data (thought this situation doesn't look like it wants that)