How to build a html table using SQL data set

[Paulos29]

Hi all,

I have a SQL database extract with a number of columns/rows. One of the column is Approver.

I want to loop through the rows to pick up all the records for each Approver and store it in array. Then I want to convert it into HTML table and and I want to create an array of tables (objects). Is creating an array of tables possible?

I should be fine with building the tables , i am not sure how to loop through the data to get the set of rows for each approver  (in an array) which i can use to then create an HTML table.