I have custom table register_otp, in that column name is_verify Table like this

        id   random_code   customer_id  is_verify

         1     Abs            15          0
         2     cfd            18          1

How to get value of is_verify based on customer id


1 Answer 1

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

$allrecord = $readconnection->select()->from(array('register_otp'=>'register_otp'));

$alldata =$readconnection->fetchAll($allrecord);

foreach($alldata as $is_verify)
     echo $is_verify['is_verify'];

you can get all data with this query

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.