Hi all,
i am stucked with this. I have to transform regular sql into Zend DB sql and
then to return values in my phtml file. After many days i am not able to
acompish that. There is my indexAction.


public function indexAction() {
                $db = Zend_Registry::get ( 'db' );
                $sql = $db->select ()
                ->from ( 'bannertype', array ('bannertypeid', 'bannercat',
'bannercatdesc', 'active','bannersacross','view_type' ) )
                ->where ( 'active = ?', 'y' )->order ( 'bannertypeid','ASC' );
                        $rez = $sql->query ();
                        $i=-1;
                        while($res = $rez->fetchAll ()){
                        foreach($res as $key=>$value){
                        $i++;
                        //print_r($res);
                        $banncat= $res[$i]['bannertypeid']; 
                        }
                        $this->view->bannerCategorie = $res;
                        $result = $db->fetchAll("SELECT ws.*,b.*,bt.*,
(SELECT COUNT(*) FROM banners b WHERE b.websiteid = ws.websiteid AND
b.bannertype= '$banncat') AS theCountCategory1,
(SELECT bannercat FROM bannertype c WHERE c.bannertypeid= '$banncat') AS
theNameCategory1
FROM websites ws left join banners b on b.websiteid=ws.websiteid 
left join bannertype bt on b.bannertype=bt.bannertypeid where
b.bannertype='$banncat' group by ws.websiteid");
echo "<pre>";print_r($result);echo "</pre>";// this gives me an array

$this->view->result = $result;// this one returns nothing to phtml :(
}
}


How to pass this result into phtml?
Thank you,
V
-- 
View this message in context: 
http://www.nabble.com/How-to-return-result-from-this-sql--tp20377930p20377930.html
Sent from the Zend Framework mailing list archive at Nabble.com.

Reply via email to