I am trying to create a menu page that displays information stored in a mySQL db. Its a list of names, addresses, etc. One of the fields in my table is 'Position' and I'd like to create a form on my menu page so that I can select a position from a drop down and only show the records that match that position.

Problem is, the values stored in the Position column are not predefined. So I am thinking I need to somehow query the db to return a list of values used in the table, then make an array with those values, and populate a drop down form field with those values as options.

Am I doing this the hard way? How can I do this?

daverozelle