MySQL Update only certain fields in a table

I have some insurance information in a 开发者_如何学Cwebsite, and I'd like to only edit certain fields the user wants to change like for example: user, id, phone, address, city

and the user wants to change his city and phone...do i have to make a query for each specific case or is there a code that can help me retrieve the key(phone) and value (9397171602)??

to then send it in a query

Basic update would take the form of:

UPDATE table_name SET column_1 = value_1, column_2 = value_2 WHERE column_3 = value_3

Where col1, col2 would be your city and phone, and col3 would be the user id. Check out the MySQL website http://dev.mysql.com/doc/refman/5.0/en/update.html for more info

There are number of ways to update a record safely. Conside the following pseudo code + php program.

class Example
{
   function UpdateRecord($editedRecord)
    {
        //Fetch existing record from the database
        $originalRecord=DB::fetchExample($editedRecord->getId()) 
        //validate each edited field and it is valid then assign its value
        //to the originalRecord's field

        if(IsValid($editedRecord->getName())
          {
            $originalRecord->setName($editedRecord->getName());
          }
        .....

        //update the record.
        $originalRecord->Update(); 
    }
}

Just add some sql to it:

$sql = "UPDATE example SET col_1 = val_1, col_9 = val_9 WHERE col_7 = val_7";
mysql_query($sql);

Then replace the columns and values with you stuff. For further info: PHP MySql Update