static public function updateTransaction() { $result = TransactionCollection::verifyFields(); if(count($result)) return ($result); $fields = explode(',','security1,Amount,account,status'); $fieldsDb = explode(',','id_isin1,amount1,id_account,status'); $partOfQuery = array(); foreach($fields as $key=>$value): $partOfQuery[]="`".$fieldsDb[$key]."` = '".$_POST[$fields[$key]]."'"; endforeach; $query = "UPDATE `transactions` SET ".implode(" , ",$partOfQuery)." WHERE id = '".$_POST['id']."';"; //echo$query; mysql_query($query); header('location: transaction_updated.php'); }