include("checksession.php"); include("antei.inc.php"); session_start(); $db = ADONewConnection("$db_tipo"); $db->Connect("$db_host", "$db_login", "$db_pass", "$database", 'sessions'); $idsubcat = $_GET['idsubcat']; $idcat = $_GET['idcat']; $name = $_GET['name']; $id = $_GET['id']; if(trim($idsubcat)=='') $idsubcat=0; // Tramite id prodotti prendo id categoria e id sottocategoria $idprodotto = $_GET['id']; // T02_UKN T02_CATEGORY T02_PRODUCT_ID #echo "IDPROD".$idprodotto."
"; // Andiamo a prendere la sotto-categoria di riferimento del prodotto $rs_subcat = $db->Execute("Select T02_CATEGORY from T02_PRODUCT where T02_UKN = ".$idprodotto.""); $idc2 = $rs_subcat->fields['T02_CATEGORY']; #echo "SUBCAT".$idc2."
"; // ora prendiamo la categoria principale $rs_subcat2 = $db->Execute("Select T01_PRIMARY_CATEGORY from T01_PRODUCT_SUBCATEGORY where T01_UKN = ".$idc2.""); $idc = $rs_subcat2->fields['T01_PRIMARY_CATEGORY']; #echo "CATPRINC".$idc."
"; //$idc = $_GET['idcat']; //$idc2 = $_GET['idsubcat']; $rs0 = $db->Execute("select * from T01_PRODUCT_CATEGORY where T01_UKN = ".$idc.""); $T01_DESCR_CAT = $rs0->fields[2]; $rs1 = $db->Execute("select * from T01_PRODUCT_SUBCATEGORY where T01_UKN = ".$idc2." order by T01_DESCR"); $T01_DESCR_CAT_2 = $rs1->fields[2]; $rs = $db->Execute("SELECT * FROM T02_PRODUCT where T02_UKN = $id"); $T02_UKN = $rs->fields[0]; $T02_PRODUCT_ID = $rs->fields[2]; $T02_CATEGORY = $rs->fields[1]; $T02_NAME = $rs->fields[3]; $T02_DESCR = $rs->fields[4]; $T02_PRICE_DB = $rs->fields[$listinopers]; $T02_PRICE = number_format($T02_PRICE_DB,2,',', '.'); $T02_ONSTOCK = $rs->fields[7]; $FILEZ = $rs->fields[18]; $T02_HR_PICTURE = $rs->fields[11]; $T02_IVA = $rs->fields[26]; if($T02_HR_PICTURE =='') $T02_HR_PICTURE = 'neutro.gif'; if($T02_ONSTOCK=='1') $T02_ONSTOCK = 'Prodotto disponibile' ; else $T02_ONSTOCK = "Prodotto momentaneamente non disponibile"; $rsc = $db->Execute("SELECT * FROM T01_PRODUCT_SUBCATEGORY where T01_UKN = $T02_CATEGORY"); $T01_DESCRIZ = $rsc->fields[2]; $rs41 = $db->Execute("SELECT * FROM T02_PRODUCT where T02_CATEGORY = ".$_GET['$idcat']." and T02_UKN=$id"); $subcateg1=$rs41->fields[1]; $rs42 = $db->Execute("SELECT T01_DESCR,T01_PRIMARY_CATEGORY FROM T01_PRODUCT_SUBCATEGORY where T01_UKN=$subcateg1"); $subcateg=$rs42->fields[0]; $categ1=$rs42->fields[1]; $rs40 = $db->Execute("SELECT * FROM T01_PRODUCT_CATEGORY where T01_UKN = $categ1"); $categ=$rs40->fields[2]; ?> Vendita accessori per la componentistica e materiale elettrico da Antei e Paolucci a La Spezia