MeanMrMustard Posted April 19, 2006 Share Posted April 19, 2006 I'm working on an incentive site.Each employee has a monthly goal - say 20 products.Each product has two incentive values - 2.00 if the total number of products sold is less than 10. $5.00 if products sold equal 11 or more. I'm trying to do a Sum and Count all in the same query. I want to know the sum of the first 10 products and then the sum of the remaining products. I have about 30 products each with different values so I can't limit it by value.Any help would be appreciated... Link to comment https://forums.phpfreaks.com/topic/7897-limiting-count/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.