i need to query the database and get a list of field names in the database so i can dump the results to an array and then loop through.
so for example, if table has FieldName(n-5) then i want a query to return
FieldName1, FieldName2, ... FieldName5
my database field names have to change frequently and so i dont want to 'hard code' it.
what would the query look like?