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.
