Disable HTML Select Option in Zend Form

We can do that using the setAttribs function in the Zend Form Element

   Ex:
      $roles = new Zend_Form_Element_Select("roles");
      $roles->setLabel("Roles");
      $roles->addMultiOptions(array('1' => 'Admin', '2'=>'Group Admin','3'=>'User'));
      suppose if we want to set it disable if the user is 'User'.
          if($roleValue > 2)
        $roles->setAttribs(array('disabled'=>'disabled'));

How to pass variable with _redirector helper zend framework

$this->_helper->_redirector('action','controller','module',array('param1'=>'value1'));

Zend Db function to get column names

$result = $this->db->query($sql_query);
$result->setFetchMode(Zend_Db::FETCH_NUM);
$metaData = $this->db->describeTable('tableName');
$columnNames = array_keys($metaData);

Zend Framework perform action without the view page

$this->_helper->viewRender->setNoRender()

OR

$this->getHelper('viewRenderer')->setNoRender()

Zend framework select() query with OR condition

$selectQry = $this->db->select()->where('fieldname = ?','value')
->orWhere('fieldname = ?','value);

How to use order and limit in select() query statement

$selectQry = $this->db->select()->from(array('MedA'=>TBL_NAME),array('answer_id','didTake','dateRecorded'))
->join(array('Med'=>TBL_NAME),
'Med.medication_id = MedA.medication_id',
array('nick_name'))
->where('MedA.is_deleted = ?',0)
->where('MedA.medication_id = ?',$medId)
->where('MedA.time_slot_id = ?',$timeSlotId)
->where('MedA.user_id = ?',$idValue)
->order('MedA.dateRecorded DESC');

if(!empty($limit))
$selectQry->limit($offset,$limit)

Zend Framework select query example with join

$this->db->select()->from(array('T1'=>'TBL_1'),array('table1_id'))
->join(array('T2'=>'TBL_2'),
'T1.site_id = T2.site_id',
array('GROUP_CONCAT( T2.name) as site_name'))
->where('T1.table1_id = ?',mysql_escape_string($tableId))