Solved

HELP QUERY, Modify Please

Posted on 2011-03-24
3
307 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

752 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