how to update multiple columns php mysql code example

Example 1: php update multiple columns

$sql = "UPDATE product_list SET product_name='".$product_name."',product_category='".$product_category."',product_price='".$product_price."',product_description='".$product_description."',size_category='".$size_category."'";

Example 2: update multiple columns in mysql

UPDATE newpurchase 
SET receive_qty = 20, pub_lang = 'Hindi', receive_dt = '2008-07-10' 
WHERE purch_price > 50;