Can someone explain me why I dont get the pictures to show up??? I have tryed everything, please advise! I’m using 2.2.1 community version. It’s an XML script feed for price comparison
//error_reporting(E_ALL);
//ini_set('display_errors', 1);
//header("Content-type: text/html; charset=utf-8");
header("Content-type: text/html");
$db_host = 'localhost';
$db_name = 'myDB';
$db_user = 'user';
$db_password = 'pass';
$link= mysql_connect ($db_host, $db_user,$db_password) or die(mysql_error());
$res = mysql_select_db($db_name,$link) or die(mysql_error());
mysql_query("SET NAMES 'utf8'", $link);
$xmlfeed="<?xml version=\"1.0\" encoding=\"utf-8\"?> \n";
$xmlfeed.=“<mystore encoding="utf8" name="store" url="http://www.mystore.com"> \n
<created_at>”.date(“Y-m-d h:i”).“</created_at>\n”;
$xmlfeed.=“\n”;
$sqlProducts=“SELECT
cscart_products.product_id AS productid,
cscart_product_descriptions.product AS title,
cscart_category_descriptions.category AS categorytitle,
cscart_categories.category_id AS categoryid,
cscart_product_prices.price,
cscart_detailed_images.image_path
FROM
cscart_categories, cscart_category_descriptions ,cscart_product_descriptions,
cscart_products, cscart_products_categories ,
cscart_product_prices , cscart_product_images_links , cscart_detailed_images
WHERE cscart_categories.category_id = cscart_category_descriptions.category_id
AND cscart_products_categories.product_id = cscart_products.product_id
AND cscart_products_categories.category_id = cscart_categories.category_id
AND cscart_product_descriptions.product_id = cscart_products.product_id
AND cscart_product_prices.product_id = cscart_products.product_id
AND cscart_product_images_links.product_id = cscart_products.product_id
AND cscart_detailed_images.image_id = cscart_product_images_links.detailed_id
AND cscart_category_descriptions.lang_code=‘EN’
AND cscart_product_descriptions.lang_code=‘EN’
AND price>0
order by price”;
$sqlProducts=“SELECT p.product_id AS productid, pd.product AS title,
cd.category AS categorytitle,
c.category_id AS categoryid,
pp.price, di.image_path, c.id_path,pil.object_type,di.image_id
FROM cscart_products p
INNER JOIN cscart_products_categories pc ON pc.product_id = p.product_id
INNER JOIN cscart_categories c ON c.category_id= pc.category_id
INNER JOIN cscart_category_descriptions cd ON c.category_id = cd.category_id AND cd.lang_code=‘EN’
INNER JOIN cscart_product_descriptions pd ON pd.product_id = p.product_id AND pd.lang_code=‘EN’
INNER JOIN cscart_product_prices pp ON pp.product_id = p.product_id
INNER JOIN cscart_images_links pil ON pil.object_id = p.product_id
LEFT JOIN cscart_images di ON di.image_id = pil.detailed_id
WHERE pp.price > 0
ORDER BY pp.price ASC”;
//echo $sqlProducts;exit;
$products = mysql_query($sqlProducts);
$lastCat=-999;
$it=0;
while ($line = mysql_fetch_array($products) ) {
$producttitle=htmlspecialchars ($line[“title”]);
$price=round($line[“price”]1.23,2);
$categorytitle= $line[“categorytitle”];
/
if ($line[“subcategoryid”]!=0){
$sqlSubCategory=“SELECT * FROM subcategories WHERE subcategoryid=‘$line[subcategoryid]’”;
$subcat = mysql_query($sqlSubCategory);
if ($subline = mysql_fetch_array($subcat) ) {
if ($subline[“title”]!=“”){
$categorytitle.=“/$subline[title]”;
}
}
}
if ($lastCat!= $line[“categoryid”]){
if ($it>0){
$xmlfeed.=“\n”;
}
$xmlfeed.=“\n”;
}/
//$path = $line[“object_type”] . “/” . floor($line[“productid”] / 1000);
$path = “thumbnails/0/” . floor($line[“image_id”] / 1000);
$xmlfeed.=“\n”;
$xmlfeed.=“”.$line[“productid”].“\n”;
$xmlfeed.=“\n”;
$xmlfeed.=“\n”;
$xmlfeed.=“\n”;
$xmlfeed.=“<category id="”.$line[“categoryid”].“">\n”;
$xmlfeed.=“<price_with_vat>$price</price_with_vat>\n”;
$xmlfeed.=“\n”;
$xmlfeed.=“\n”;
//$xmlfeed.=“\n”;
//$xmlfeed.=“\n”;
$xmlfeed.=“Y\n”;
$xmlfeed.=“ÃŽ?αι\n”;
print “<img src="http://www.mystore.com/images/“.$path.”/“.$line[“image_path”].”\” />“;
$xmlfeed.=”\n";
$it++;
$lastCat= $line[“categoryid”];
}
//$xmlfeed.=“\n”;
$xmlfeed.=“\n”;
$xmlfeed.=“”;
//$xmlfeed= str_replace(“<”,"", $xmlfeed);
print $xmlfeed;
?>
Anyone Please as I have alredy paid the price comparison site!