Cannot get the pics from DB

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

//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=""> \n

<created_at>”.date(“Y-m-d h:i”).“</created_at>\n”;



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_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);



while ($line = mysql_fetch_array($products) ) {

$producttitle=htmlspecialchars ($line[“title”]);


$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”]!=“”){





if ($lastCat!= $line[“categoryid”]){

if ($it>0){





//$path = $line[“object_type”] . “/” . floor($line[“productid”] / 1000);

$path = “thumbnails/0/” . floor($line[“image_id”] / 1000);






$xmlfeed.=“<category id="”.$line[“categoryid”].“">\n”;








print “<img src="“.$path.”/“.$line[“image_path”].”\” />“;



$lastCat= $line[“categoryid”];





//$xmlfeed= str_replace(“<”,"
", $xmlfeed);

print $xmlfeed;


Anyone Please as I have alredy paid the price comparison site!

Anyone? Please advise as I have already paid the price comparison site and I cannot get it to work!

Got It Solved!

[quote name='tasmanos' timestamp='1317199855' post='122463']

Got It Solved!


How did you do it… grrr!!! why would u say u got it solved and not share the answer!!!

I'm assuming it had something to do with those cdata tags - how did you remove them?

The mod was completly wrong, I had to buy a new one.