very easy SQL question

[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?

[cfU]

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

[Nathan]

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

[Clarion]

I believe...

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

...it should work for ya.

[calmlikeabomb]

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?

$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......