static public function loadTransaction() { TransactionCollection::checkId(); $query = "SELECT t.* , c.abbreviation, i.fund_name name FROM transactions t, fund i,currency c WHERE t.id = '".$_GET['id']."' AND t.id_isin1 = i.id AND i.currency = c.id"; $qres=mysql_query($query); $row=mysql_fetch_assoc($qres); if(empty($row)) die('wrong id, please contact admin.'); $fieldsDb = explode(',','types,id_isin1,amount1,abbreviation,name,id_account,comment_user,status'); $fields = explode(',','types,security1,Amount,Currency,Name,account,comment,status'); foreach($fields as $key=>$value) $_POST[$value] = $row[$fieldsDb[$key]]; }