Zend php在查询中设置不同

Question

how to stop to show duplicate value using zend query pls suggest

 public function getProductCategoryById($id) {
        $where = array(
            "product_category_id = ?" => $id
        );
        $result = $this->_db_table->fetchRow($where);
//        print_r($result);die;
        if (!$result) {

            return false;
        }
        $product_category = new Application_Model_ProductCategories($result);
        return $product_category;
    }

I am new zend user Iam confuse how to use distinct value in zend pls take a look my code and do changes

Pls assist

Answer 1

Use distinct

$select = $this->select()
              ->distinct()
              ->where('product_category_id = ?', $id);