I want to display all the records from the Table using For loop

Question

Here in this code i have to display all the records from the Table(cust_college). but this function is returning me only 1'st row of that table not other rows.please tell me solution

$read = Mage::getSingleton('core/resource')->getConnection('core_read');
$a = "SELECT * from cust_college";

$qry = $read->query($a);
$res = $qry->fetch(PDO::FETCH_ASSOC); //fetch row
foreach ($res as $payment) {
    echo $payment = $res[college];
    echo $payment = $res[value_id];
    echo $payment = $res[shop_id];
    echo $payment = $res[cust_address];
}

$store = Mage::app()->getStore()->getCode();

Your own comment says it all: //fetch row not //fetch all rows — Mark Baker, Aug 13 '12 at 11:56
Hey Mark i did all the probability with the fetch_ASSOC but still getting 1 row multiple times — Supriya, Aug 13 '12 at 12:07
You should create a model to access the table ... this is the right way to work with magento and db — WonderLand, Aug 13 '12 at 12:30

score 0 · Accepted Answer · answered Aug 13 '12 at 12:03

0

$result = $read->getSelect()->getAdapter()->fetchAll('SELECT * from cust_college');

answered Aug 13 '12 at 12:03

Guerra

2,792
1
22
32

Hi Guerra thanks for replying but this query is not running . please tell me different code to run – Supriya Aug 13 '12 at 12:11
Hey Guerra thank you very much. My Query is running . – Supriya Aug 13 '12 at 12:33

I want to display all the records from the Table using For loop

1 Answers1