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




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

$xmlfeed.=“http://www.mystore.com"> \n

”.date(“Y-m-d h:i”).“\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.=“\n”;

$xmlfeed.=“$price\n”;

$xmlfeed.=“\n”;

$xmlfeed.=“\n”;

//$xmlfeed.=“\n”;

//$xmlfeed.=“\n”;

$xmlfeed.=“Y\n”;

$xmlfeed.=“ÃŽ?αι\n”;

print “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!

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!

[/quote]



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.