Adding a drop down list of DB values

i’m trying to add a dropdown list that contains a columns values populated from the database, when a value is selected a result table on the same page should change accordingly … any suggestions?

i am using the following code
//this is for the search
[abase form=”1,search” table=”courses” columns=”vendor=%vendor%,domain=%domain%,location=%location%$Search” elements=”vendor,domain,location”]

//this is the affected table
[abase table=”courses” columns=”name,vendor,domain,location,certification,description” where=”AND status=’1′”echo=”0″]

https://www.ads-software.com/plugins/abase/