ZEND_DN and Multiple table JOIN

I am using the ZEND_DB adapter class and I creating a query with a join clause. When I call my  the adapter class it run forever.

I am not using db_select. This my own create query. However, if I call the method without any join it works.

Here is the class and function

class DatabaseService
{
            
      function DatabaseService($dbinfo,$dbname="")
      {
            
            try
            {
            $dbConfig = array(
                'host'     => $this->host,
                'username' => $this->username,
                'password' => $password,
                'dbname'   => $this->dbname );
            $this->db = Zend_Db::factory($this->adapter, $dbConfig);       
                Zend_Db_Table::setDefaultAdapter($this->db);
            }
            catch(Zend_Exception $e)
            {
                  $this->error = $e->getMessage();
                  Helper::log($this->error);
                  return false;
            }
      }
      
   public function fetchall($sql)
      {
            $res= $this->db->fetchAll($sql);
            return $res;
      }
}
SiemensSENAsked:
Who is Participating?
 
SiemensSENConnect With a Mentor Author Commented:
I  drop and re-create the index
0
 
mcbSolutionsCommented:
Please post the query.

Does the query work in phpMyAdmin or QueryBrowser?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.