I want to populate a search field menu from our database.
I tried the example below but am not getting any results.
Select District as SearchOption, District as SearchOptionValue from Events Where District = '$District'
If I replace $District with a value the query works.