Normal MYSQL QUERY to ZEND QUERY

Asked Nov 04 '14 at 05:59

Active Nov 04 '14 at 06:03

Viewed 44 times

I Want to write this normal mysql query to zendquery

SELECT *,(select GROUP_CONCAT(keyword_name,',') 
   from keyword k inner join keyword_product_mapping m 
       where k.keyword_id=m.keyword_id and m.product_id=p.product_id) 
           FROM product p

edited Nov 04 '14 at 06:03

Code Lღver

15,573
16
56
75

asked Nov 04 '14 at 05:59

Tecrizon Shared

Did you make any attempts to solve it that you could share? – Joachim Isaksson Nov 04 '14 at 06:01
Exactly i dont know how to write sub query in zend. The normal query is a working one. – Tecrizon Shared Nov 04 '14 at 06:04
First write the subquery in Zend, then write the main query (without specifying the subquery) in Zend. Post that here and we'll be able to help you with patching them together ;-). – Mihai Stancu Nov 04 '14 at 09:22
Maybe it will help you http://stackoverflow.com/questions/4922246/how-execute-query-with-subqueries-in-zend-framework – newage Nov 04 '14 at 12:22

Normal MYSQL QUERY to ZEND QUERY

0 Answers0