title: how to fetch the current user data in phpfox
body: <p>Topic: Fetch current user(some particular fields) data from the DB and display it on the Welcome Screen. <br></p>
  
  <p>Explaination of UI : On the Registration Page, A dropdown would appear. As the user selects an option, it would trigger an event to fetch user image to show on the welcome page.</p>
  
  <p>I have put following code in (pages.process) module</p>
  
  <pre><code>  function getUserId($iUserId)
          {
          $aRows = $this-&gt;database()-&gt;select('p.image_path')-&gt;from($this-&gt;_sTable, 'p')
  -&gt;Join(Phpfox::getT('user') , 'u', ' p.page_id = u.college_name') -&gt; 
          where('u.college_name = p.page_id AND u.user_id = ' . 
      (int)$iUserId)-&gt;execute('getRows');
              return $aRows;
              }
  </code></pre>
  
  <p>The data will selected from User &amp; Pages Table, and will be used to show the user image. Please suggest.</p>