Alright, my next problem in what I figure will be a LONG line of mySQL query problems... lol
My example database is like this
ENTRY 1 : Bob, The Zoo, 3
ENTRY 2 : Frank, The Zoo, 4
ENTRY 3 : Tom, The Park, 5
What I want is a query that will find the one in the middle (called category), and list them out, but not puting any duplicates. For example, if it was to use the above database I gave then the output would be:
The Zoo
The Park
Is there any way to do this or no?