Search code examples
phpdatabasemagentoblogsposts

How to fetch recent 3 post from a blog table: magento


I have a table in database as "neotheme_blog_post" and there are many post in there, now i want to fetch recent 3 posts from this table and show them on home page: I have tried to fetch the data as follows but nothing worked:

    <?php $connection = 
      Mage::getSingleton('core/resource')->getConnection('core_read');
      $query      = "Select * FROM 'neotheme_blog_post'";
      $rows       = $connection->fetchAll($query);

      foreach ($rows as $values) {
      echo $name = $values['name'];

      }?>

Solution

  • In my case i get the three recent posts as like follows using neotheme blog extension:

         $connection = 
         Mage::getSingleton('core/resource')->getConnection('core_read');
         $query = "Select * FROM neotheme_blog_post ORDER BY created_at DESC LIMIT 3 ";
         $rows = $connection->fetchAll($query);
         foreach ($rows as $values) {
         $post_titile = $values['cms_identifier'];
         echo '<div>';
         echo '<h1>' . $name = $values['title'] . '</h1>';
         echo $summery = $values['summary'];
         echo '<a href="' . $this->getUrl().'blog/'.  $post_titile . '">Read More</a>';
          echo '</div>';