In this recipe, we will learn how to update information in a database table. We assume that a users database table already exists, comprising of three columns—email_address, password, and address_of_delivery (please see the beginning of this chapter, where we learned to create a database and a table in it). On entering an email address, all the current information of the user (that is, their password and address of delivery) will be displayed. Thereafter, the user will be prompted to enter a new password and address of delivery. This new information will be updated against the current information in the table.