title: Showing Product Description as Category List Description - OpenCart
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/8052068/spliting-results-of-php-query-into-columns">Spliting Results of PHP Query into Columns</a>  </p>
  </blockquote>
  
  
  
  <p>I have the following line of code that pulls the description from the database,</p>
  
  <p>What I am trying to do is add <code>&lt;br/&gt;</code> to the description so that it is not shown as one long string of data.</p>
  
  <p><code>mb_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, 100) . '..'</code></p>
  
  <p><strong>Current:</strong></p>
  
  <p>Data Data Data Data Data Data.Data Data.Data Data.Data Data</p>
  
  <p><strong>Required:</strong></p>
  
  <p>Data Data</p>
  
  <p>Data Data</p>
  
  <p>Data Data</p>
  
  <p><strong>Full Code:</strong></p>
  
  <pre><code>            $this-&gt;data['products'][] = array(
                  'product_id'  =&gt; $result['product_id'],
                  'thumb'       =&gt; $image,
                  'name'        =&gt; $result['name'],
                  'description' =&gt; mb_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, 100) . '..',
                  'price'       =&gt; $price,
                  'special'     =&gt; $special,
                  'tax'         =&gt; $tax,
                  'rating'      =&gt; $result['rating'],
                  'reviews'     =&gt; sprintf($this-&gt;language-&gt;get('text_reviews'), (int)$result['reviews']),
                  'href'        =&gt; $this-&gt;url-&gt;link('product/product', 'path=' . $this-&gt;request-&gt;get['path'] . '&amp;product_id=' . $result['product_id'])
              );
  </code></pre>