title: strip blank lines from output
body: <p>I have code which is creating a XML document for Google Shopping. Google is getting hung up on a blank line. I do not know how to strip the lines out. The code is pulling from a Magento Commerce database.</p>
  
  <pre><code>&lt;?php echo '&lt;?xml version="1.0" ?&gt;'; ?&gt;
  &lt;rss version="2.0" xmlns:g="http://base.google.com/ns/1.0" xmlns:c="http://www.base.google.com/cns/1.0"&gt;
  &lt;channel&gt;
  &lt;title&gt;Spray Foam Systems&lt;/title&gt;
  &lt;link&gt;http://www.sprayfoamsys.com/store/&lt;/link&gt;
  &lt;description&gt;Spray Foam Rigs, Spray Foam Equipment, Sprayfoam Parts and Supplies.&lt;/description&gt;
  
  &lt;?php
  $con = mysql_connect(REMOVED) or die(mysql_error());
      if (!$con)
          {
              die('Could not connect: ' . mysql_error());
          }
      mysql_select_db("sprayfoa_store", $con);
  
      $query = mysql_query("SELECT * FROM `catalog_product_flat_1` WHERE `visibility` = 4 ORDER BY entity_id ASC")
      or die(mysql_error());
  ?&gt;
  
  &lt;?php
      while($row = mysql_fetch_array($query))
          {
  ?&gt;
  &lt;item&gt;
  &lt;g:id&gt;&lt;?php echo $row['entity_id']; ?&gt;&lt;/g:id&gt;
  &lt;title&gt;&lt;?php echo $row['name']; ?&gt;&lt;/title&gt;
  &lt;description&gt;&lt;?php echo $row['short_description']; ?&gt;&lt;/description&gt;
  &lt;g:google_product_category&gt;Business &amp;amp; Industrial &amp;gt; Construction&lt;/g:google_product_category&gt;
  &lt;g:product_type&gt;Spray Foam Parts &amp;amp; Supplies &amp;gt; Fusion AP Parts&lt;/g:product_type&gt;
  &lt;link&gt;http://sprayfoamsys.com/store/&lt;?php echo $row['url_path']; ?&gt;&lt;/link&gt;
  &lt;g:image_link&gt;http://sprayfoamsys.com/store/media/catalog/product&lt;?php echo $row['small_image']; ?&gt;&lt;/g:image_link&gt;
  &lt;g:condition&gt;new&lt;/g:condition&gt;
  &lt;g:availability&gt;in stock&lt;/g:availability&gt;
  &lt;g:price&gt;&lt;?php echo $row['price']; ?&gt;&lt;/g:price&gt;
  &lt;g:brand&gt;
  &lt;?php
  $entity_id = $row['entity_id'];
  $query2 = mysql_query("SELECT * FROM `catalog_product_entity_varchar` WHERE entity_id = '$entity_id' AND attribute_id = '127'")
  or die(mysql_error());  
      while($row2 = mysql_fetch_array($query2))
          {
              echo $row2['value'];
  } ?&gt;
  &lt;/g:brand&gt;
  &lt;g:mpn&gt;&lt;?php echo $row['sku']; ?&gt;&lt;/g:mpn&gt;
  &lt;/item&gt;
  
  
  &lt;?php
  }
  mysql_close($con);
  ?&gt;
  
  &lt;/channel&gt;
  &lt;/rss&gt;
  </code></pre>
  
  <p>The output looks like:</p>
  
  <pre><code>&lt;item&gt;
  &lt;g:id&gt;15&lt;/g:id&gt;
  &lt;title&gt;DK 817 - Gun Cleaning Solvent and Lubricator - Aerosol Can 16 oz. &lt;/title&gt;
  &lt;description&gt;DK 817 is a cleaner-lubricant used on for cleaning polyurethane dispensing equipment and guns.  DK817 comes in a 16 oz. aerosol can.  Contractors praise it's ability to quickly clean components with uncured polyurethane materials.  &lt;/description&gt;
  &lt;g:google_product_category&gt;Business &amp;amp; Industrial &amp;gt; Construction&lt;/g:google_product_category&gt;
  &lt;g:product_type&gt;Spray Foam Parts &amp;amp; Supplies &amp;gt; Fusion AP Parts&lt;/g:product_type&gt;
  &lt;link&gt;http://sprayfoamsys.com/store/dk-817-gun-cleaning-solvent-and-lubricator-aerosol-can.html&lt;/link&gt;
  &lt;g:image_link&gt;http://sprayfoamsys.com/store/media/catalog/product/d/k/dk817.jpg&lt;/g:image_link&gt;
  &lt;g:condition&gt;new&lt;/g:condition&gt;
  &lt;g:availability&gt;in stock&lt;/g:availability&gt;
  &lt;g:price&gt;24.9900&lt;/g:price&gt;
  &lt;g:brand&gt;brand
  &lt;/g:brand&gt;
  &lt;g:mpn&gt;partnumber&lt;/g:mpn&gt;
  &lt;/item&gt;
  
  
  &lt;item&gt;
  &lt;g:id&gt;16&lt;/g:id&gt;
  &lt;title&gt;Allegro Full Mask SAR Replacement Lens 9901-09L&lt;/title&gt;
  &lt;description&gt;Replacement lens for the 9901 Series Allegro Full Face Mask.  Clear, scratch resistant lens.  Easy to replace.  Lens only.
  
  Allegro 9901-09L&lt;/description&gt;
  &lt;g:google_product_category&gt;Business &amp;amp; Industrial &amp;gt; Construction&lt;/g:google_product_category&gt;
  &lt;g:product_type&gt;Spray Foam Parts &amp;amp; Supplies &amp;gt; Fusion AP Parts&lt;/g:product_type&gt;
  &lt;link&gt;http://sprayfoamsys.com/store/allegro-full-mask-sar-replacement-lens-9901-09r.html&lt;/link&gt;
  &lt;g:image_link&gt;http://sprayfoamsys.com/store/media/catalog/product/a/l/al-9901-09l-1.jpg&lt;/g:image_link&gt;
  &lt;g:condition&gt;new&lt;/g:condition&gt;
  &lt;g:availability&gt;in stock&lt;/g:availability&gt;
  &lt;g:price&gt;75.0000&lt;/g:price&gt;
  &lt;g:brand&gt;
  Allegro&lt;/g:brand&gt;
  &lt;g:mpn&gt;9901-09L&lt;/g:mpn&gt;
  &lt;/item&gt;
  </code></pre>
  
  <p>The first item passes through no problem as the description tag has no blank lines, however the second item, give me a XML formatting error, the only thing I can think of is the blank line in the description tag</p>