Экспорт товаров в XML

[Tatjana]

Здравствуйте!

 

Не могли бы подсказать, как мне добавить в файл зкспорта название товаров и категорий на втором языке.

// get products
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");
$req=mysql_query('SELECT pd.product_id, pc.category_id,cd.name AS cat, pd.name AS name, p.price as price, ps.price as aprice, p.model,p.image FROM product_description pd

INNER JOIN product p
   ON (pd.product_id=p.product_id)

LEFT JOIN product_special ps ON (ps.product_id=p.product_id)     
INNER JOIN product_to_category pc
   ON (pc.product_id=pd.product_id)
INNER JOIN category c ON(c.category_id=pc.category_id )
INNER JOIN category_description cd ON(cd.category_id=c.parent_id or cd.category_id=c.category_id and c.parent_id=0)   
WHERE cd.language_id=3 and pd.language_id=3 and p.status=1

');

$fp=fopen('/salidzini.xml','w');
$start='<?xml version="1.0" encoding="utf-8"?>
<root>
';
fwrite($fp,$start);

while($row=mysql_fetch_assoc($req)){
    $price=number_format($row['price'],2,'.','');
    $aprice=number_format($row['aprice'],2,'.','');
    $image=str_replace(" ","%20",$row['image']);
    $xml.="<item>\n";
    $xml.="\t\t<name>".$row['name']."</name>\n";
       
    $xml.="\t\t<link>".HTTP_SERVER."index.php?route=product/product&amp;product_id=".$row['product_id']."</link>\n";
    if ($aprice == 0) {$xml.="\t\t<price>".$price."</price>\n";}
    else {$xml.="\t\t<price>".$aprice."</price>\n";}
    
    $xml.="\t\t<image>".HTTP_SERVER."image/".$image."</image>\n";
    $xml.="\t\t<category_full>".$row['cat']."</category_full>\n";
    
    $xml.="\t\t<category_link>".HTTP_SERVER."index.php?route=product/category&amp;path=".$row['category_id']."</category_link>\n";
    $xml.="</item>\n";
    }
    fwrite($fp,$xml);
    
    fwrite($fp,'</root>');