Jump to content

Count results not accurate


greg

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.