Wordpress UPDATE Query Syntax

$update_meta_item = $pdo->prepare("
						UPDATE wp_postmeta
						SET meta_value = :price WHERE meta_key = '_regular_price' AND post_id = '$prod_id',
							meta_value = :price WHERE meta_key = '_price' AND post_id = '$prod_id',
							meta_value = :quantity WHERE meta_key = '_stock' AND post_id = '$prod_id'"); 
					
					
					try	{
						$update_meta_item->execute(array(
						':quantity'=>$data[16],
						':price'=>$data[3])) or die(print_r($update_meta_item->errorInfo()));
						echo '<b>'.++$cnt .'</b> -- Product ID: <b>'. $title.' </b> has been updated.<br />';
						
						}
						catch(PDOException $aa) {
   							echo 'ERROR: ' . $aa->getMessage();
						}

Select all Open in new window