Hello kris1511,

Well it seems the monks have provided you the solution to your problem already. But taking this opportunity I think it would be better to use fetchrow_arrayref or fetchrow_array or selectall_arrayref.

From what I am seeing you querying you DB to fetch the all the data where you could simply fetch only one column. There is a similar question with sample of code that replicates the behavior for fetchrow_array() and also selectall_arrayref() how to save data to new array after retrieving from sql server.

Update: Also you can find some code examples here extract column data.

Hope this helps, BR.