Trying to understand how to echo from array

Actually, $this->db->query("...")->result() does not return an array, but an object.
If you do want an array, use $this->db->query("...")->result_array();
In order to output the results in your view, do this:

PHP Code:

<?php
foreach ($social as $soc) {
  echo $soc['social_name'];
}
?>