Search the Database

SELECT categories.ID AS v, category AS l FROM categories, listings WHERE categories.ID IN (category1,category2,category3) GROUP BY category ORDER BY category

SELECT town AS v, town AS l FROM towns, listings WHERE towns.town=listings.city GROUP BY listings.city ORDER BY town