Alright let me try to put this question so it's understandable. I am doing that Band database and in fact I am able to do majority of the band related content in my band plugin but there is one that I can't and it's albums. So what I am doing is that I made a plugin for albums which contains the whole discography of each band.
I have made the album form and everything else is simple but then there should be a dropdown that lists all the bands and I choose to which band that particular album belongs to. Atm my admin_config.php contains the following
$this->fields['bandid']['writeParms']['optArray'] = array('bandid_0','bandid_1', 'bandid_2'); // Example Drop-down array. And that populates dropdown like in the picture
I would need to make the dropdown according to a database query to the band table and list them on that dropdown with bandid as the option value and bandname as option text. I know how to do all the queries etc but I don't know how to place the query result to that array.
Any help would be greatly appreciated cause atm I am stuck with this.