Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function feedbackaverageAction(){
- $value =$_GET['value'];
- $db = Zend_Registry::get('dbadapter');
- $select = new Zend_Db_Select($db);
- $select = $db->select();
- $select->from(array('feedback' => 'feedback'),
- array ('customdata',
- 'checkinprocess',
- 'service_by_owner',
- 'locationrating',
- 'cleanlinessrating',
- 'valueformoneyrating',
- 'kitchenequipmentrating'));
- $select->where('feedback.checkinprocess' +
- 'feedback.service_by_owner' +
- 'feedback.locationrating' +
- 'feedback.cleanlinessrating' +
- 'feedback.valueformoneyrating' +
- 'feedback.kitchenequipmentrating' <= $value);
- $stmt = $select->query();
- $result = $stmt->fetchAll();
- $this->view->rows = $result;
- }
- $value = $_GET['value'];
- $db = Zend_Registry::get('dbadapter');
- $select = new Zend_Db_Select($db);
- $select = $db->select();
- $select->from(array('feedback' => 'feedback'),array ('customdata','checkinprocess','service_by_owner','locationrating','cleanlinessrating','valueformoneyrating','kitchenequipmentrating'));
- $select->where(new Zend_Db_Expr('feedback.checkinprocess'+'feedback.service_by_owner'+'feedback.locationrating'+'feedback.cleanlinessrating'+'feedback.valueformoneyrating'+'feedback.kitchenequipmentrating')<= $value);
- $stmt = $select->query();
- $result = $stmt->fetchAll();
- $this->view->rows = $result;
Add Comment
Please, Sign In to add comment