mysql updating multiple column values from array variable

Solutions on MaxInterview for mysql updating multiple column values from array variable by the best coders in the world

showing results for - "mysql updating multiple column values from array variable"
Lucia
17 Jan 2017
1$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."'";
Michele
23 Jun 2020
1"UPDATE product_list 
2set 
3product_name='$product_name', 
4product_category ='$product_category', 
5product_price='$product_price',
6product_description='$product_description',
7product_size_category='$size_category'
8where product_id='$product_id'
9"
similar questions