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 suggestions are welcome...
Thanks in advance...
<?php
$con = mysql_connect("localhost","catyrtyreyercasad","!1reyreyrtyXwTk");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
//http://www.paulwhippconsulting.com.au/webdevelopment/50-sorting-magento-categories-alphabetically-with-mysql
mysql_select_db("casryrtytryad",$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" encoding="iso-8859-1" ?>';
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 '<pname>' . $row1['product_name'].'</pname>' ;
echo '<price>' .$row1['price'].'</price>' ;
echo '<special_price>' .$row1['special_price'].'</special_price>' ;
echo '<weight>' .$row1['weight'].'</weight>' ;
echo '<image>[url]http://infocomsoftware.com/foodcart/media/catalog/product/cache/1/small_image/170x/9df78eab33525d08d6e5fb8d27136e95[/url]' . $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>';
?>