> Many at a times, users would like to update their information in your website such as the username, or email or the reset a password
> We thus must therefore provide the with this functionality to change these things according to user needs.
> To enhance this, we use the UPDATE query in PHP queries.
> we can specify which data we want to update the data using the WHERE clause
> For example let’s change the name Brianfrom previous example to John and
email email@example.com to firstname.lastname@example.org Example - MYSQL Update
mysql_query("UPDATE users SET username='$username',email='$email' WHERE username='$old_username'") or die(mysql_error());