Hi Experts, I have This query (code attached)
It works now but i need to add another column for the number of handsets a user owns. to do this i need to count the number of rows in the customer_details table where the customer_name is the name of the company to the left column. for example if Anna norris has 4 records in out customer_details table then she would have 4 handsets by counting the individual rows (indeitfied by the mobile_number) which is unique to one person obviously.
So this query needs changeing to include the customer_details table count every mobile number which = the company name and display the output in the column to the right of company in the attached picture. see code and picture.
Many thanks for your time.
$query2 = "SELECT SUM(Jan09), SUM(Feb09),SUM(Mar09),SUM(Apr09),SUM(May09),SUM(Jun09),SUM(Jul09),SUM(Aug09),SUM(Sep09),SUM(Oct09),SUM(Nov09),SUM(Dec09) FROM bill_detail2009";
This is the query i know there is a join needing to be used somewhere just dont know where or how to get my desired output.