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]];

  }