View Single Post
Old 02-10-2005, 01:57 PM  
Zester
Confirmed User
 
Zester's Avatar
 
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
Zester is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote