how to get list of categories from a non-relational database
Posted: Thu Sep 28, 2006 12:26 pm
I have a database that I didn't design... nor do I have any control over... and it is set up like this:
What would be the most efficient way to select all categories without duplicates IE:
restaurants
lawyers
landscapers
Code: Select all
category memid address etc.
"restaurants" 23 1234 Ros rd. Bla
"lawyers" 234 3214 Poo rd. BLAB
"restaurants" 23213 1123 Foo Rd. asdf
"landscapers" 675 5485 Lelu rd. asdfkj
"restaurants" 7642 234 Poopies 234restaurants
lawyers
landscapers