CreedFeed Posted November 6, 2007 Share Posted November 6, 2007 I have the following query: SELECT stores.id, stores.name, SUM(orders.total), SUM(orders.cost), COUNT(orders.id) FROM stores LEFT JOIN orders ON stores.id = orders.store_id AND orders.date_ordered > 'xxxx-xx-xx xx:xx:xx' GROUP BY stores.id How would I create that same query using DB_DataObjects? I have the following: $orders = new Orders (); $stores = new Base_stores (); $stores->selectAdd (); $stores->selectAdd (' stores.id, stores.name, SUM(orders.total) as total, SUM(orders.order_cost) as cost, COUNT(orders.id) as num_orders '); $stores->joinAdd ($orders, 'LEFT'); $stores->groupBy ('base_stores.id'); which gives the following query: SELECT stores.id, stores.name, SUM(orders.total) as total, SUM(orders.order_cost) as cost, COUNT(orders.id) as num_orders FROM base_stores LEFT JOIN orders ON (orders.base_store_id=base_stores.id) GROUP BY base_stores.id How do I add on the orders.date_ordered > 'xxxx-xx-xx xx:xx:xx' to the query using DB_DataObject syntax??? Thanks! Link to comment https://forums.phpfreaks.com/topic/76219-pear-db_dataobject-help/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.