Ответ

Безымянный 17.05.2004 14:26

Делаю следующее: в файл proba.html помещаю код

^connect[$connect_string]{
$товары[^table::sql{
	SELECT
		product.Name AS "Name",
		company.Name AS "Company",
		company.Sort,
		subgroup.Name AS "Subgroup",
		subgroup.Name_One,
		maingroup.Name AS "Maingroup",
		company.ID,
		subgroup.ID,
		product.ID AS "ProductID",
		product.Price,
		product.ImgSmall,
		product.Desc_short
	FROM
		product,
		company,
		subgroup,
		maingroup
	WHERE
		product.Subgroup = subgroup.ID AND
		maingroup.ID = subgroup.Main_Group AND 
		company.ID = product.company AND product.Subgroup = "$form:fields.group"
	ORDER BY
		Name_One, Sort, Company, Name
	
}]
}

<?xml version="1.0" encoding="windows-1251"?>
<!DOCTYPE yml_catalog SYSTEM "shops.dtd">

<yml_catalog date="^date_now.sql-string[]"> 

<shop>
<name>BestShop</name>
<company>Best online seller Inc.</company>
<url>http://best.seller.ru/</url>

<offers>

^товары.menu{

<offer id=$товары.ProductID>

<company>$товары.Company</company>
<model>$товары.Name</model>
<price>$товары.Price</price>

<offer>

}	


</offers>
</shop>


</yml_catalog>

---