Hi all. I have this code:
$select->from(array('a' => 'ads'),array( 'a.id_ad', 'a.title',
'a.insert_date', 'a.id_status', 'i.image'))
->join(array('i' => 'images'), 'a.id_ad = i.id_ad')
->where('a.id_company = ?',$user->id_company)
->where('a.id_status = 1')
->orWhere('a.id_status = 2')
->where('i.mainImage = 1')
->order('a.id_ad desc')
;
The resultant select query is :
SELECT `a`.`id_ad`, `a`.`title`, `a`.`insert_date`, `a`.`id_status`,
`i`.`image`, `i`.* FROM `ads` AS `a`
INNER JOIN `images` AS `i` ON a.id_ad = i.id_ad WHERE (a.id_company = '1') AND
(a.id_status = 1) OR (a.id_status = 2) AND (i.mainImage = 1) ORDER BY
`a`.`id_ad` desc
But the "where" that I want (for a.id_status elements) is :
(a.id_status = 1 OR a.id_status = 2) [now is (a.id_status = 1) OR
(a.id_status = 2) ]
How can I do it ?
M.
--
Michel 'ZioBudda' Morelli mic...@ziobuddalabs.it
Consulenza sistemistica in ambito OpenSource.
Sviluppo applicazioni web dinamiche (LAMP+Ajax)
Telefono: 0200619074
Telefono Cell: +39-3939890025 -- Fax: +39-0291390660
http://www.ziobudda.net ICQ: 58351764
http://www.ziobuddalabs.it Skype: zio_budda
http://www.ajaxblog.it MSN: mic...@ziobuddalabs.it
JABBER: mic...@gmail.com
