hi, i have a section in my database for categories.. example "Cars". there are 40 "Cars" listings. there are other categories as well. I want to be able to pull out one sample from each category so that it is a representative of that category.. heh, let me clarify with an example:
cars
cars
cars
dogs
dogs
dogs
dogs
people
people
people
okay, that is what i have when i select * from the database. now i want to pull just one out of each so that i get a result like this:
cars
dogs
people
ideas on how to do this?
thx,
blue
cars
cars
cars
dogs
dogs
dogs
dogs
people
people
people
okay, that is what i have when i select * from the database. now i want to pull just one out of each so that i get a result like this:
cars
dogs
people
ideas on how to do this?
thx,
blue