I have got a table in the database called
#__magazines, this holds data for magazines (date published, issue number etc..). I have created a Component, Plugin and Module which is for Joomla 3.x, I want to be able to have the module display variables (let's use Published Dates as an example) which if they are chosen and then the "Search" button is clicked, the module will go to the database and then bring back all of the results which match the chosen date and display the results in a new page.
I've followed the Joomla tutorials, but I can't workout the best way to query the
#__magazines table and then display the results.
I have now got the search plugin working correctly, so if I search for a magazine title (which I know is in the database) it appears in the search results.
What I want to know however, is how I can display all of the different variables from the database table of
#__magazines and show them as dropdowns in a search module but not have duplicates. For example, if there is a
June 2014 and this is in the database twice, I only want it to show in the Select Option dropdown once, if it is then chosen and the "Search" button clicked the user is taken to the results page, where the multiple version of the "June 2014" details are shown.