very easy SQL question - GoFuckYourself.com

Zester · 02-10-2005, 01:57 PM

I need a simply SQL query to get the amount of 'Approved' galleries I have in database, and the amount of 'Pending' galleries I have in database

what do I use?

it should be something like this:

SELECT * count(status='Approved') approved, count(status='Pending') pending
FROM galleries

what do you say?

cfU · 02-10-2005, 02:05 PM

select status, count(*)
from galleries
where status in ('Approved','Pending')
group by status

Nathan · 02-10-2005, 02:06 PM

SELECT SUM(IF(status='Approved',1,0)) approved, SUM(IF(status='Pending',1,0)) pending FROM galleries;

Clarion · 02-10-2005, 02:07 PM

I believe...

SELECT * count(status='Approved') as approved, count(status='Pending') as pending
FROM galleries

...it should work for ya.

calmlikeabomb · 02-10-2005, 02:20 PM

Quote:

Originally Posted by Zester

I need a simply SQL query to get the amount of 'Approved' galleries I have in database, and the amount of 'Pending' galleries I have in database

what do I use?

it should be something like this:

SELECT * count(status='Approved') approved, count(status='Pending') pending
FROM galleries

what do you say?

Code:

$approvedquery = "SELECT * FROM galleries WHERE status='Approved'";
$approved = @mysql_results($approvedquery);
$numapproved = mysql_num_rows($approved);

There are currently $numapproved approved galleries.

That would be the correct way to do it......

02-10-2005, 01:57 PM	#1
Zester Confirmed User Industry Role: Join Date: Jul 2003 Posts: 5,344	very easy SQL question I need a simply SQL query to get the amount of 'Approved' galleries I have in database, and the amount of 'Pending' galleries I have in database what do I use? it should be something like this: SELECT * count(status='Approved') approved, count(status='Pending') pending FROM galleries what do you say? __________________ * Mainstream ? $65 per sale * new male contraception

02-10-2005, 02:06 PM	#3
Nathan Confirmed User Industry Role: Join Date: Jul 2003 Posts: 3,108	SELECT SUM(IF(status='Approved',1,0)) approved, SUM(IF(status='Pending',1,0)) pending FROM galleries; __________________ "Think about it a little more and you'll agree with me, because you're smart and I'm right." - Charlie Munger

02-10-2005, 02:07 PM	#4
Clarion Confirmed User Join Date: Jan 2005 Location: Ontario, OR Posts: 148	I believe... SELECT * count(status='Approved') as approved, count(status='Pending') as pending FROM galleries ...it should work for ya. __________________ Structure Northwest :: the cure for the common code :: AIM: Asatruel \| Yahoo!: Asatruel \| ICQ: 111-638-053

02-10-2005, 02:05 PM	#2
cfU Confirmed User Join Date: Jan 2003 Posts: 933	select status, count(*) from galleries where status in ('Approved','Pending') group by status