greg Posted May 28, 2012 Share Posted May 28, 2012 I'm trying to get the number of rows of each group after gouping products_quantity_order_min using the following query but the results are not accurate. Any idea? Thanks $qty_min ="SELECT p.products_quantity_order_min, p.products_price, p.products_rush_service, pd.products_name, COUNT(*) AS `count` from products p left join products_description pd on p.products_id= pd.products_id where p.products_rush_service = 1 group by products_quantity_order_min order by products_quantity_order_min asc"; Link to comment https://forums.phpfreaks.com/topic/263287-count-results-not-accurate/ Share on other sites More sharing options...
Barand Posted May 28, 2012 Share Posted May 28, 2012 Any idea? Without knowing your data, what count you are getting and what count you expect - no Link to comment https://forums.phpfreaks.com/topic/263287-count-results-not-accurate/#findComment-1349341 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.