radar Posted July 30, 2010 Share Posted July 30, 2010 I have a table in my database named order, and i want to count the quantity sold. i have the basic query already setup like: $sql = "SELECT SQL_CALC_FOUND_ROWS deal.id, deal.title, deal.min_qty, deal.start_date, deal.end_date, deal.status, deal.secondary, count(o.id) as orders_cnt FROM deals as deal LEFT JOIN orders as o on o.d_id = deal.id WHERE start_date >= '".$beg."' AND start_date <= '".$end."' GROUP BY o.d_id, deal.id ORDER BY start_date LIMIT ".AwsPager::getCurrentIndex().", ".AwsPager::getLimit(); Which would theoretically work, but in the orders table, there is a column named quantity, and its those numbers that i need to add together and store in the array as orders_cnt.. any clue how i can do that? Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted July 30, 2010 Share Posted July 30, 2010 SUM(`quantity`), perhaps? Quote Link to comment Share on other sites More sharing options...
radar Posted July 30, 2010 Author Share Posted July 30, 2010 hmm i may have to try that and see what i come up with.... i havent ever used the SUM param. lemme try it out Beautiful it works like a charm.. thanks for suggesting sum Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted July 30, 2010 Share Posted July 30, 2010 My pleasure. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.