I have a page that selects the next available password. It then uses another statement to update that record and flag the is_used column to 1 i.e. used.<BR><BR>A third statement inserts that password, along with other details - name, address etc. - into the customer table.<BR><BR>The page then redirects to a confirmation page, that does no writing to the db, so that refreshing the page has no adverse effects.<BR><BR>My problem is that more than one password is being flagged as used.