[SOLVED] Easy Syntax Error - using COUNT, HAVING, and GROUP BY

[techtheatre]

I am trying to find out how many orders in my shopping cart database have a particular "Status".  I can't seem to get this rather simple query correct.  Here is some of what i have tried:

 

SELECT COUNT(Status) FROM InvoiceData HAVING Status='Processing Payment' GROUP BY Status; 

SELECT COUNT(*) FROM InvoiceData WHERE Status='Processing Payment' GROUP BY Status; 

SELECT COUNT(*) FROM InvoiceData HAVING Status='Processing Payment' GROUP BY Status; 

 

My table is "InvoiceData" and there are several columns, but one is called "Status"...There are a variety of possible values for Status in the table.

 

THANKS!  I feel like an id10t that i cannot get this correct.  Maybe i should try sleeping... :-\

[techtheatre]

I am an idiot...

 

here is the correct query:

SELECT COUNT(*) FROM InvoiceData WHERE Status='$value'; 

 

I really am going to bed now...this is ridiculous...