xml parsing error

This page contains the following errors:

error on line 20 at column 508: Encoding error
Below is a rendering of the page up to the first error.



I was uploading this code url in two servers One it is working correctly but in magento based site it is not working....

All suggesions are welcome...
Thanks in advance...

PHP Code:

---

<?php
$con = mysql_connect("localhost","casdfhefhsad","!1hfhfhfhfhk");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}



  mysql_select_db("carhhehd",$con);
  
  
  $result=mysql_query( "SELECT `main_table`.`entity_id`,`main_table`.`level`, `main_table`.`path`, `main_table`.`position`,
 `main_table`.`is_active`, `main_table`.`is_anchor`,
 `main_table`.`name` FROM
 `catalog_category_flat_store_1` AS `main_table`
   
 WHERE (path LIKE '1/2/%') AND (main_table.store_id = '1') AND
(is_active = '1') AND (include_in_menu = '1') ORDER BY name ASC");  
  
  header("Content-type: text/xml");   
echo '<?xml version="1.0" ?>';

echo '<data>';
  
  
   $i=0;
while($row=mysql_fetch_array($result)) 
{
    $m=$i+1;
      echo '<'.$row['name'].'>';
    
     echo '<entity_id>' . $row['entity_id'] .'</entity_id>';
    
    echo '<store_id>' . '1'.'</store_id>' ;
      
     echo '<name>' . $row['name'].'</name>' ;
      
      
    $b=$row['name'];     

    
$result1=mysql_query("SELECT distinct 
        
         p.entity_id AS 'product_entity_id',
         
            cvn.name AS 'cname',
        cvn.entity_id AS 'centityid', 
        


           pvn1.entity_id AS 'entity_id',
           pvn1.name AS 'product_name',
           pvn1.price AS 'price',
        
           pvn1.special_price AS 'special_price',
           pvn1.weight AS 'weight',
           pvn1.small_image AS 'small_image',
           pvn1.short_description AS 'short_description',
           pvn1.url_key AS 'url_key'


FROM 
catalog_product_entity p 
JOIN(
      SELECT DISTINCT entity_id, attribute_id,value
      FROM 
   catalog_product_entity_varchar )  pvn 
ON p.entity_id = pvn.entity_id 
  JOIN (
      SELECT DISTINCT entity_id, name, price,special_price,weight,small_image,short_description,url_key
      FROM    catalog_product_flat_1 ) pvn1
        ON pvn.entity_id=pvn1.entity_id
JOIN (
      SELECT DISTINCT product_id,category_id
      FROM   catalog_category_product_index ) r 
ON r.product_id = p.entity_id 
JOIN (
      SELECT  entity_id 
      FROM

catalog_category_entity) c 
ON r.category_id = c.entity_id 
JOIN (
      SELECT `cvn`.`entity_id`,`cvn`.`level`, `cvn`.`path`, `cvn`.`position`,
 `cvn`.`is_active`, `cvn`.`is_anchor`,
 `cvn`.`name` FROM
 `catalog_category_flat_store_1` AS `cvn`
   
 WHERE (path LIKE '1/2/%') AND (cvn.store_id = '1') AND
(is_active = '1') AND (include_in_menu = '1') ORDER BY name ASC ) cvn 
ON c.entity_id = cvn.entity_id 
WHERE 
cvn.name = '$b' 

ORDER BY pvn.value;"); 



if($result1)
{


    while($row1=mysql_fetch_array($result1)) 
{
      
        
        
        
        
       echo '<products>';

     
       echo '<centity_id>' . $row1['centityid'] .'</centity_id>';
       
          echo '<cname>' . $row1['cname'].'</cname>' ;
    
    echo '<pentity_id>' . $row1['entity_id'] .'</pentity_id>';
    
    echo '<sku>' . $row1['sku'].'</sku>' ;
      
     echo '<name>' . $row1['product_name'].'</name>' ;
       
      echo '<price>' .$row1['price'].'</price>' ;
          

       echo '<special_price>' .$row1['special_price'].'</special_price>' ;
       
        
       echo '<weight>' .$row1['weight'].'</weight>' ;
       
       

        echo '<image>http://infocomsoftware.com/foodcart/media/catalog/product/cache/1/small_image/170x/9df78eab33525d08d6e5fb8d27136e95' . $row1['small_image'] . '</image>';
           

        
       echo'<short_description>' . $row1['short_description'] . '</short_description>' ;
         
            
          echo'<url_key>' . $row1['url_key'].'</url_key>' ;
          
            
      
        echo '</products>';  
   
}
}
  echo '</' . $row['name'].'>';   
}

echo'</data>';


?>

---

Since you say all suggestions welcome, I would suggest that the error is not in the PHP code, but in the xml code it produces. Which is a difference in how the PHP code is interpreted. When you have the page in the browser, hit 'View Source'. Do this on the page where everything is working, and also on the page where you are getting the error. Try to see what is different. That might give you a clue as to how to fix it.



Oh, and when posting code in the forums:

Please use the forum's bbcode tags to indent your code and make it more readable:

for php code............[php] <?php /* code goes here */ ?> [/php]
for html...............[html] <!-- markup goes here -->.....[/html]
for js/css/other.......[code] code goes here................[/code]

The simple editor has a button for the [code][/code] tag, you may use that:

#

Not the #i one, which is really just for highlighting.

The advanced editor (activated by using the 'Go Advanced' button from the simple editor) has buttons for PHP and HTML code braces as well.

I and another moderator already edited your post to fix this, this time because you are new. In the future, please try to use the bbcode tags for any code that you want to put in your posts.