title: Extract CSV values from an array and display them Individually as a List
body: <p>I have an array of CSV values in my Database like category1[obj1,obj2,obj3..]</p>
  
  <p><strong>View</strong></p>
  
  <pre><code>&lt;?php echo $row_company-&gt;category1;?&gt;
  </code></pre>
  
  <p><strong>Controller</strong></p>
  
  <pre><code>$row_company = $this-&gt;employers_model-&gt;get_company_details_by_slug($company_name);
  </code></pre>
  
  <p>The employers_model then calls a procedure which in turn executes the required query which displays the contents of row = category1 in this fashion,</p>
  
  <p><strong>obj1,obj2,obj3...</strong></p>
  
  <p>I want to be able to show this result without the commas and as a list like this</p>
  
  <ul>
  <li>obj1</li>
  <li>obj2</li>
  <li>obj3..</li>
  </ul>
  
  <p>I'm Using CodeIgniter MVC Framework, I have some vague idea about the uses of implode function, and came across  preg_split too, But don't know where to start meddling around from, the view or the controller.
  Any direction towards the solution would be appreciated.</p>
  
  <p><strong>Edit : row_company in detail.</strong></p>
  
  <pre><code>$row_company = $this-&gt;employers_model-&gt;get_company_details_by_slug($company_name);      
  
      if(!$row_company){
          redirect(base_url(),'');
          exit;   
      }
  
      $company_website = ($row_company-&gt;company_website!='')?validate_company_url($row_company-&gt;company_website):'';
      $data['row_company']        = $row_company;
      $data['company_logo']       = $company_logo;
      $data['company_join']       = $company_join;
      $data['company_website']    = $company_website;
      $data['company_location']   = $company_location;
      $data['title']              = $row_company-&gt;company_name.' jobs in '.$row_company-&gt;city;
      $this-&gt;load-&gt;view('company_view',$data);
  }
  </code></pre>
  
  <p>employers_model content</p>
  
  <pre><code>public function get_company_details_by_slug($slug) {
      $Q = $this-&gt;db-&gt;query('CALL get_company_by_slug("'.$slug.'")');
      if ($Q-&gt;num_rows &gt; 0) {
          $return = $Q-&gt;row();
      } else {
          $return = 0;
      }
      $Q-&gt;next_result();
      $Q-&gt;free_result();
      return $return;
  }   
  </code></pre>
  
  <p>the procedure itself <strong>get_company_details_by_slug</strong></p>
  
  <pre><code>BEGIN
  SELECT emp.ID AS empID, emp.sts1, pc.ID, emp.country, emp.city, pc.company_name, pc.company_description, pc.company_location, pc.company_website, pc.no_of_employees, pc.established_in, pc.company_logo, pc.company_slug, pc.category1, pc.category2, pc.category3, pc.company_join
  FROM `pp_employers` AS emp 
  INNER JOIN pp_companies AS pc
  WHERE pc.company_slug=slug  AND emp.sts1 ='active';END
  </code></pre>