HOLA ! ES MI PRIMERA VEZ ASÍ QUE CORREGIRME SI ME EQUIVOCO EN ALGO POR FAVOR.
ESTOY ARMANDO UN FEED DE MIS PRODUCTOS PARA OLX, LUEGO DE COMPRAR UN MODULO XML FEED, Y NOTAR QUE NO ME SIRVE PORQUE NO EXPORTA DATOS DE USUARIO, ME DECIDI A ARMARLO YO MISMO.
LO TENGO EN UN 95% TERMINA, EPCEPTO UN PROBLEMA, CUANDO LISTO LAS FOTOS (LA CANTIDAD VARIA DEPENDE DEL PRODUCTO) ESTAS SE CARGAN TODAS JUNTAS EN EL PRIMER PRODUCTO, Y TODO EL RESTO QUEDA SIN FOTOS, CREO QUE ESTA MAL MI FORECH, HACE DOS DIAS ME ESTOY ROMPIENDO LA CABEZA SIN PODER HACER QUE FUNCIONE, AGRADECERIA UNA MANITO ...
MI CODIGO
<?header ("Content-type: text/xml");
echo ("<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>");
?>
<ADS>
<?php
mysql_connect ("localhost", "Mercadodelusado", "Mercado2015") or die ("Cannot connect to database server.");
mysql_select_db ("tienda_presta") or die ("Cannot connect to database.");
$result = mysql_query ("
SELECT
ma_marketplace_seller_product.id,
ma_marketplace_seller_product.product_name,
ma_marketplace_seller_product.short_description,
ma_marketplace_seller_product.date_add,
ma_product.condition,
ma_product.price,
ma_marketplace_shop_product.id_product,
ma_marketplace_seller_product.id_seller,
ma_marketplace_seller_info.business_email,
ma_marketplace_seller_info.id,
ma_marketplace_seller_info.phone,
ma_image.id_image,
ma_product_lang.link_rewrite,
ma_product_lang.id_product,
ma_image_shop.id_product,
ma_image.id_product
FROM
ma_marketplace_seller_product
JOIN
ma_product
JOIN
ma_marketplace_shop_product
JOIN
ma_marketplace_seller_info
JOIN
ma_image
JOIN
ma_product_lang
JOIN
ma_image_shop
ON
ma_product.id_product=ma_marketplace_shop_product. id_product
AND
ma_marketplace_shop_product.marketplace_seller_id_ product=ma_marketplace_seller_product.id
AND
ma_marketplace_seller_info.id=ma_marketplace_selle r_product.id_seller
AND
ma_product_lang.id_product=ma_marketplace_shop_pro duct.id_product
AND
ma_image.id_product=ma_product_lang.id_product
LIMIT 50
") or die (mysql_error());
while ($row = mysql_fetch_array ($result)) {
echo "<AD>";
echo "<ID><![CDATA[".$row['id']."]]></ID>";
echo "<TITLE><![CDATA[".$row['product_name']."]]></TITLE>";
echo "<DESCRIPTION><![CDATA[".$row['short_description']."]]></DESCRIPTION>";
echo "<DATE><![CDATA[".$row['date_add']."]]></DATE>";
echo "<EMAIL><![CDATA[".$row['business_email']."]]></EMAIL>";
echo "<LOCATION_COUNTRY><![CDATA[ARG]]]></LOCATION_COUNTRY>";
// echo "<LOCATION_STATE><![CDATA[CONSULTAR]]]></LOCATION_STATE>";
echo "<LOCATION_CITY><![CDATA[Mar del Plata]]]></LOCATION_CITY>";
echo "<ZIP_CODE><![CDATA[B7600]]]></ZIP_CODE>";
echo "<CATEGORY><![CDATA[378]]]></CATEGORY>";
echo "
<IMAGE_URL><![CDATA[http://www.mercadoautomotor.com.ar/".$row['id_image']."-thickbox_default/".$row['link_rewrite'].".jpg]]]></IMAGE_URL>
";
echo "<PRICE><![CDATA[".$row['price']."]]]></PRICE>";
echo "<PHONE><![CDATA[".$row['phone']."]]]></PHONE>";
echo "<CONDITION><![CDATA[".$row['condition']."]]]></CONDITION>";
echo "</AD>";
}
mysql_free_result ($result);
?>
</ADS>
