Solved

HELP QUERY, Modify Please

Posted on 2011-03-24
3
267 Views
Last Modified: 2012-08-14
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.

Open in new window

newpicture1.jpg
0
Comment
Question by:NeoAshura
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
Lukasz Chmielewski earned 500 total points
ID: 35206764
$query2 = "SELECT company_name, count(customer_name) as howmuch, 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 left join customer_details on customer_name = company_name";

try it or post some more - it would be nice to have a tables structure
0
 
LVL 6

Author Comment

by:NeoAshura
ID: 35206897
Ive sorted this now, What i did was insted of using the customer name, I added the unquie mobile numbers in the table of the customer based on the customer name so if 4 numbers had the same customer the count would be 4 and so on.. This is sorted but yours would work too so i will award points.
0
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 35206903
Thank you.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now