Welcome to WebmasterWorld Guest from 54.147.134.218

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

finding how many X occur in a database

how many different galleries there are

     
3:54 am on Jul 22, 2011 (gmt 0)

New User

joined:June 18, 2011
posts: 3
votes: 0


I have a database with a table called 'media' which has a field named 'gallery'

I want to check all the rows and count how many different galleries exist.
6:31 am on July 22, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Apr 19, 2002
posts:3171
votes: 8


what have you tried so far?

you should look into using DISTINCT