0) { while ($row = mysql_fetch_row($res)) { $CategoryID = $row[0]; $CategoryName = $row[1]; echo("$CategoryName
"); } } mysql_free_result($res); */ ?>

Каталог продуктов:

0 && $scid == 0 && $scid1 == 0 && $pid == 0) { $CategoryName = ""; $CategoryDescr = ""; $res = mysql_query("SELECT Name, Descr FROM tbl_category WHERE CategoryID = $cid AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $CategoryName = $row[0]; $CategoryDescr = str_replace("\n", "
", $row[1]); } mysql_free_result($res); echo("$CategoryName ->

"); $res = mysql_query("SELECT SubCategoryID, Name FROM tbl_subcategory WHERE CategoryID = $cid AND IsActive = 1 ORDER BY Name"); if (mysql_num_rows($res) > 0) { while ($row = mysql_fetch_row($res)) { $SubCategoryID = $row[0]; $SubCategoryName = $row[1]; echo("$SubCategoryName
"); } } echo("$CategoryDescr"); mysql_free_result($res); } // Вывод список подкатегорий 1 и информации выбранной подкатегории if ($cid > 0 && $scid > 0 && $scid1 == 0 && $pid == 0) { $CategoryName = ""; $res = mysql_query("SELECT Name FROM tbl_category WHERE CategoryID = $cid AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $CategoryName = $row[0]; } mysql_free_result($res); $SubCategoryName = ""; $SubCategoryDescr = ""; $res = mysql_query("SELECT Name, Descr FROM tbl_subcategory WHERE SubCategoryID = $scid AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $SubCategoryName = $row[0]; $SubCategoryDescr = $row[1]; } mysql_free_result($res); echo("$CategoryName -> $SubCategoryName ->

"); $res = mysql_query("SELECT SubCategory1ID, Name FROM tbl_subcategory1 WHERE SubCategoryID = $scid AND IsActive = 1 ORDER BY Name"); if (mysql_num_rows($res) > 0) { while ($row = mysql_fetch_row($res)) { $SubCategory1ID = $row[0]; $SubCategory1Name = $row[1]; echo("$SubCategory1Name
"); } } echo("

$SubCategoryDescr

"); mysql_free_result($res); } // Вывод список продуктов и информации выбранной подкатегории 1 if ($cid > 0 && $scid > 0 && $scid1 > 0 && $pid == 0) { $CategoryName = ""; $res = mysql_query("SELECT Name FROM tbl_category WHERE CategoryID = $cid AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $CategoryName = $row[0]; } mysql_free_result($res); $SubCategoryName = ""; $res = mysql_query("SELECT Name, Descr FROM tbl_subcategory WHERE SubCategoryID = $scid AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $SubCategoryName = $row[0]; } mysql_free_result($res); $SubCategory1Name = ""; $SubCategory1Descr = ""; $res = mysql_query("SELECT Name, Descr FROM tbl_subcategory1 WHERE SubCategory1ID = $scid1 AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $SubCategory1Name = $row[0]; $SubCategory1Descr = str_replace("\n", "
", $row[1]); } mysql_free_result($res); echo("$CategoryName -> $SubCategoryName -> $SubCategory1Name ->

"); $res = mysql_query("SELECT ProductID, Name, Descr FROM tbl_product WHERE SubCategoryID = $scid1 AND IsActive = 1 ORDER BY Name"); if (mysql_num_rows($res) > 0) { echo(""); echo(""); $img_num = 0; $img_max_num = 2; while ($row = mysql_fetch_row($res)) { $ProductID = $row[0]; $ProductName = $row[1]; $ProductDescr = $row[2]; echo(""); echo(""; print ""; $img_num++; if(!($img_num%$img_max_num)) echo ""; } echo("
"); if (file_exists("admin/catalog/pictures/product_price_$ProductID.jpg")) echo(""); echo(""); echo("$ProductName
"); echo substr($ProductDescr,0,150); echo ("... Смотреть
"); print "
"); } echo("

$SubCategory1Descr

"); mysql_free_result($res); } // Вывод информации о выбранном продукте if ($cid > 0 && $scid > 0 && $scid1 > 0 && $pid > 0) { $CategoryName = ""; $res = mysql_query("SELECT Name FROM tbl_category WHERE CategoryID = $cid AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $CategoryName = $row[0]; } mysql_free_result($res); $SubCategoryName = ""; $res = mysql_query("SELECT Name FROM tbl_subcategory WHERE SubCategoryID = $scid AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $SubCategoryName = $row[0]; } mysql_free_result($res); $SubCategory1Name = ""; $res = mysql_query("SELECT Name, Descr FROM tbl_subcategory1 WHERE SubCategory1ID = $scid1 AND IsActive = 1"); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $SubCategory1Name = $row[0]; } mysql_free_result($res); $ProductName = ""; $ProductDescr = ""; $res = mysql_query("SELECT Name, Descr ,Descr2 ,Coords FROM tbl_product WHERE ProductID = $pid AND IsActive = 1"); $w=600; $h=400; $ProductDescr2 =""; if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); $ProductName = $row[0]; $ProductDescr = str_replace("\n", "
", $row[1]); $ProductDescr2 = str_replace("\n", "
", $row[2]); $Coords = $row[3]; if ($Coords != "") list($w,$h) = split("\*", $Coords); } mysql_free_result($res); echo("$CategoryName -> $SubCategoryName -> $SubCategory1Name -> $ProductName ->

"); echo("

$ProductName

"); echo("

"); if (file_exists("admin/catalog/pictures/product_$pid.jpg")) echo(""); echo"
"; if (file_exists("admin/catalog/pictures/product_pdf_$pid.pdf")) echo(" "); if (file_exists("admin/catalog/pictures/product_pdf_$pid.jpg")) echo(" "); echo("
$ProductDescr $Descr2
"); //if (file_exists("admin/catalog/pictures/product_pdf_$pid.pdf")) // echo(" Дополнительное описание e pdf

"); } include "footer.php"; include("db_close.php"); ?>