If order is what you want then you prob should do fetchrow_arrayref instead of hashref. Just my two cents, I would assume the only reason you care about order is because you want to display it out agian looking like the same table. The alternative would be to just have an array of the columns in the order you want to display them.