<?php

class Travelogue_Model_Travelogue {

    protected $_dbTable;

    protected $objHelperGeneral;
    
    protected $tablename;
    protected $tablenameDes;


    public function __construct() {
        $this->objHelperGeneral = Zend_Controller_Action_HelperBroker::getStaticHelper('General');
        $this->tablename = "tbl_travelogues";
        $this->db = Zend_Db_Table::getDefaultAdapter(); 
    }
 
    
    
    /**
    * rv_select_all() method is used to get all listing
    * @param table name, columns array, where array, order array
    * @return array result set
    */
    
    public function get_group_destination( $tablename , $ids )
    {
//        $dbtable = new Zend_Db_Table($tablename);
//        $select = $dbtable->select()->from("$tablename as tbl", $columns);
        
        $sql    = "SELECT group_concat(title) as title FROM `$tablename` where DesSysId in ($ids)";

        $select = $this->db->fetchRow($sql);
        return $select['title'];
    }
    
    
    

}