title: opencart add extrafield to account
body: <p>I just created a row in table customer. I have a module that writes information there. It works fine, but I cannot display this field in template here is what I have changed:
  catalog/model/account/customer.php</p>
  
  <pre><code>$sql = "SELECT *, CONCAT(c.firstname, ' ', c.lastname,' ',c.competition_rate,c) AS name, cg.name AS customer_group FROM " . DB_PREFIX . "customer c LEFT JOIN " . DB_PREFIX . "customer_group cg ON (c.customer_group_id = cg.customer_group_id) ";
  </code></pre>
  
  <p>catalog/view/template/default/ommon/header.php</p>
  
  <pre><code>&lt;?php echo $competition_rate; ?&gt;
  </code></pre>
  
  <p>catalog/controller/common/header.php</p>
  
  <pre><code>$this-&gt;data['text_logged'] = sprintf($this-&gt;language-&gt;get('text_logged'), $this-&gt;url-&gt;link('account/account', '', 'SSL'), $this-&gt;customer-&gt;getFirstName(),$this-&gt;customer-&gt;getcompetition_rate(), $this-&gt;url-&gt;link('account/logout', '', 'SSL'));
  </code></pre>
  
  <p>And I am getting the following </p>
  
  <blockquote>
    <p>Fatal error: Call to undefined method Customer::getcompetition_rate() in C:\xampp\htdocs\sport\catalog\controller\common\header.php on line 76</p>
  </blockquote>
  
  <p>What am I missing? Please help! The information of this row is available throu PhpMyadmin</p>