Здравствуйте!
 
	 
 
	Не могли бы подсказать, как мне добавить в файл зкспори название товаров и категорий на втором языке.
 
	// 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&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&path=".$row['category_id']."</category_link>\n"; 
	    $xml.="</item>\n"; 
	    } 
	    fwrite($fp,$xml); 
	     
	    fwrite($fp,'</root>');