Ответов: 8 Просмотров: 12907
|
Помогите, пожалуйста, выдается ошибка:
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home6/tanoutle/public_html/sali dzini.php on line 29
На эту строчку - while($row=mysql_fetch_assoc($req))
$req=mysql_query("SELECT p.product_id,pc.category_id,cd.name, model,image,price FROM oc_product p INNER JOIN product_to_category pc
ON (pc.product_id=p.product_id) LEFT JOIN category_description cd ON(cd.category_id=pc.category_id) WHERE cd.language_id=3");
$fp=fopen('/home6/tanoutle/public_html/exports/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,'.','');
$xml.="<item>\n";
$xml.="\t\t<name>".$row['model']."</name>\n";
$xml.="\t\t<link>".HTTP_SERVER."index.php?route=product/product&product_id=".$row['product_id']."</link>\n";
$xml.="\t\t<price>".$row['price']."</price>\n";
$xml.="\t\t<image>".HTTP_SERVER.$row['image']."</image>\n";
$xml.="\t\t<category_full>".$row['name']."</category_full>\n";
$xml.="\t\t<category_link>".HTTP_SERVER."index.php?route=product/category&path=".$row['category_id']."</category_link>\n";
$xml.="\t\t<manufacturer>".$row['name']."</manufacturer>\n";
$xml.="\t\t<model>".$row['model']."</model>\n";
$xml.="</item>\n";
}
fwrite($fp,$xml);
fwrite($fp,'</root>');
fclose($fp); |