Welcome, Guest. Please login or register.
Did you miss your activation email?
Jan 05, 2009, 08:32:32 PM

There is no security on this earth, there is only opportunity.

- General Douglas MacArthur

Home

Help

Welcome Guest - Register or Login Now to remove these advertisments

Registration is completely free and only takes a few minutes to signup !

Entrepreneur Forum > Webmasters - Discuss Making Money Online > Website Design and Maintenance > Database

How can I use count() multiple times in one query ?

0 Members and 1 Guest are viewing this topic.

Pages: [1]

Author

Topic: How can I use count() multiple times in one query ? (Read 257 times)

CrackerJack

New Member

Joined: Jul 2008
Posts: 41

$View CrackerJack\s Profile$

United States

Jul 23, 2008, 01:20:37 PM

I need to write a sql statement for mysql that counts the number of records that contain a specific value and null using one query instead of lots of separate queries.

I tried this query but it's not working

Code:

SELECT site_stat,
COUNT(site_stat='Approved') AS "approved",
COUNT(site_stat='NULL') AS "not approved"
FROM sites
GROUP BY site_stat

How can I do this? Is it even possible ?

09f9 New DVD Releases

AceCoder

Junior Member

Joined: Oct 2007
Posts: 64

$View AceCoder\s Profile$

Germany

Jul 27, 2008, 09:13:41 PM

You'll have to use a JOIN statement on that query if you want to do multiple count statements.

Latest Blog Post : PHP - Pass by Reference or Pass by Value

AceCoder's Programming Tips