ArticleAuthor::GetArticlesByAuthor PHP Method

    public static function GetArticlesByAuthor($p_authorId)
    {
        global $g_ado_db;
        $queryStr = 'SELECT fk_article_number, fk_language_id, fk_type_id
                     FROM ' . self::TABLE . '
                     WHERE fk_author_id = ' . (int) $p_authorId;
        $rows = $g_ado_db->GetAll($queryStr);
        $returnArray = array();
        foreach ((array) $rows as $row) {
            $article = new Article((int) $row['fk_language_id'], (int) $row['fk_article_number']);
            $type = new AuthorType((int) $row['fk_type_id']);
            $returnArray[] = array('article' => $article, 'type' => $type);
        }
        return $returnArray;
    }

      <div class="textHolder omega">
        <textarea name="txt_biography" id="txt_biography" rows="30" class="tinymce input_text_area"><?php echo $biography; ?></textarea>
      </div>
    </fieldset>
    <div class="clear"></div>
  </div>

  <?php
  if (is_object($author)) {
  ?>
  <div id="contentContainer">
    <div class="space-box"></div>
    <fieldset class="frame">
      <ul>
    <?php
    $authoringList = ArticleAuthor::GetArticlesByAuthor($author->getId());
    $authoringCount = sizeof($authoringList);
    if ($authoringCount > 0) {
    ?>
        <li>
          <label><?php putGS('Total articles'); ?>:</label> <span><?php echo $authoringCount; ?></span></li>
    <?php
        foreach ($authoringList as $authoringItem) {
            $articleUrl = $Campsite['WEBSITE_URL'] . '/' . $ADMIN . '/articles/edit.php';
            $articleUrl .= '?f_publication_id=' . $authoringItem['article']->getPublicationId()
                . '&f_issue_number=' . $authoringItem['article']->getIssueNumber()
                . '&f_section_number=' . $authoringItem['article']->getSectionNumber()
                . '&f_article_number=' . $authoringItem['article']->getArticleNumber()
                . '&f_language_id=' . $authoringItem['article']->getLanguageId();
    ?>
        <li>