Counting

[radar]

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?

[Pikachu2000]

SUM(`quantity`), perhaps?

[radar]

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

[Pikachu2000]

My pleasure.