"; print_r($_GET); echo ""; $sDocRoot = $_SERVER["DOCUMENT_ROOT"]; if($_GET["kindc"] && $_GET["typec"] && $_GET["codec"]) { {# DB Connection include $sDocRoot . '/lib/dbconn.class'; $oDBC = new DBConnection; $aDBC["eld_sdb"] = $oDBC->connect("eld_sdb"); } $sLink = "price_right.html?"; if($_GET["product_view"] == 'SHOT') { $sLink .= "shot=Y"; } $sQry = "SELECT el_cate_c1, el_cate_c2, el_prod_c FROM tmap_pc_prod WHERE kind_c='".$_GET["kindc"]."' AND type_c='".$_GET["typec"]."' AND prod_c='".$_GET["codec"]."'"; $nRslt = mysql_query($sQry, $aDBC["eld_sdb"]); $nCnt = mysql_num_rows($nRslt); if($nCnt>0) { $aRow = mysql_fetch_array($nRslt); $sLink .= "cate1=".$aRow["el_cate_c1"]."&cate2=".$aRow["el_cate_c2"]."&pcode=".$aRow["el_prod_c"]; } echo ""; } exit;