DataObjects "HAVING" ?
| From: | ThE PhP_KiD | Date: | Wed, 04 Jun 2003 17:26:07 +0000 |
| Subject: | DataObjects "HAVING" ? | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-5795@lists.php.net to get a copy of this message | ||
Hi !
There is a way to put a "HAVING" on a SQL sentence with
DataObject ?
(without use "query()" method)
---------------------------------------------
Example:
I want to perform next query:
SELECT id_lot FROM rel_lot_countries
WHERE id_country=251 OR id_country=245 OR id_country=246
GROUP BY id_lot HAVING count(*)=3
--------------------------------------------------
And, with DataObjects, I have next code:
$rel_lot_countries=new DataObjects_Rel_lot_countries();
$total=count($_POST['countries']);
$foreach($_POST['s_countries'] as $val) {
$rel_lot_countries->whereAdd('id_country='.$val,'OR');
}
$rel_lot_countries->groupBy('id_lot');
????? $rel_lot_countries->having ????
--------------------------------------------------
Help me !!
Thank you
Regards,
mac
--
...ThE PhP_KiD.