The $sth->finish() isn't doing anything; there's an implicit $sth->finish() when $sth->fetchrow_hashref() gets to the end of the result set in your while loop.
I think that another session had a lock on the table, which was causing the UPDATE statement to block, and that this other session has since released the lock. I created my own ChunkMail table, and the original script worked just fine. Ronald > -----Original Message----- > From: Laurie Vien [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 24, 2004 4:08 PM > To: 'James D. White'; Laurie Vien > Cc: '[EMAIL PROTECTED]' > Subject: RE: Why won't my script terminate? > > Thank you very much to everyone who replied. The combination of your > answers put me on the right path; I got it! > > I moved the "$sth->finish();" up to right after the close of the While > loop, > instead of leaving it at the end of the script. That solved it. > > Thanks, all, for your help. > > Laurie >
