Skip to main content
added 255 characters in body
Source Link
Arunendra
  • 7.5k
  • 3
  • 29
  • 55

You can use below mentioned code

//database read adapter 

$read = Mage::getSingleton('core/resource')->getConnection('core_read'); 

$results = $read->fetchAll("select * from your_tablename"); 
foreach($results as $r$row)
{
    var_dump($r);echo "<i><b>Author Name:</b></i>";
    echo $row["name"];
    echo "<br /><i><b> Comment: </i></b>";
    echo $row["comment_txt"];
    echo "<br /><i><b>Date: </i></b>";
    echo $row["comment_date"];
    echo "<br><br>";
}

For more read here.

You can use below mentioned code

//database read adapter 

$read = Mage::getSingleton('core/resource')->getConnection('core_read'); 

$results = $read->fetchAll("select * from your_tablename"); 
foreach($results as $r)
{
    var_dump($r);
}

For more read here.

You can use below mentioned code

//database read adapter 

$read = Mage::getSingleton('core/resource')->getConnection('core_read'); 

$results = $read->fetchAll("select * from your_tablename"); 
foreach($results as $row)
{
    echo "<i><b>Author Name:</b></i>";
    echo $row["name"];
    echo "<br /><i><b> Comment: </i></b>";
    echo $row["comment_txt"];
    echo "<br /><i><b>Date: </i></b>";
    echo $row["comment_date"];
    echo "<br><br>";
}

For more read here.

Source Link
Arunendra
  • 7.5k
  • 3
  • 29
  • 55

You can use below mentioned code

//database read adapter 

$read = Mage::getSingleton('core/resource')->getConnection('core_read'); 

$results = $read->fetchAll("select * from your_tablename"); 
foreach($results as $r)
{
    var_dump($r);
}

For more read here.