I have a program installed on my Joomla website called joomla music solution. [url removed, login to view]
You may view my website to see at [url removed, login to view]
You will notice the search field. There are two sections. “Search Albums” and “Search Demos”.
The back end of the program you are able to load songs and albums. After you load data you input information into tables, such as genera, gender, age range etc…
There are two separate sections to input information. One for albums, and one for songs.
In albums - the tables are “types” “tags” “genera” “format”. (I have renamed the fields on the front end)
In song - the tables are “genera”.
The “genera” table is the same database for both albums and songs.
What I need are additional static tables in each field “songs” and “albums”
Albums – I need one table for “Languages”
Songs – I need “Languages,” “Age range,” “Gender,” “Demo genera (or Demo type)”
I need these tables searchable on the front end page.
So when I search for “demos” I can search for Age range, gender, Demo type and language and I will receive the appropriate listings.
When I search for Albums, everything will be as is, but I will also be able to include languages.
As mentioned, the lists can be static, or “pre-defined”. So, I do not need to add new options later since they will never change.
I have attached screen shots of the backend.
Here is the information on music solution:
Music Collection follows Joomla! 1.5 component developing standards, so PHP familiar users will find easy to find and understand most of Music Collection's core functionalities. Programming logic is completely separated of content display, so designers won't need to change source code in order to adapt Music Collection into their site's look & feel.
PHP and MySQL
Hi!, music collection is a great component but in fact, sometimes it needs more fields to be added (depending on the costumer needs). Please check private messages for more detailing information.