//gyo //kubun //kubun2 include "../dbconnect.php"; include "bukken_item.php"; for($cnt = 0;$cnt < count($arr);$cnt++){ if(strstr($arr[$cnt],$_REQUEST["kubun"].":")){ $item = explode(":",$arr[$cnt]); $DB_vt_name = $item[3]; } } if($_REQUEST["kubun"] == "d"){ $_REQUEST["kubun1"] = "a"; }else{ $_REQUEST["kubun1"] = $_REQUEST["kubun"]; } if($_REQUEST["kubun1"] == "a"){ if($_REQUEST["kubun"] == "d"){ if($_REQUEST["kubun2"]){ $sql = " and kubun1 = '".$_REQUEST["kubun1"]."' and kubun3 = '".$_REQUEST["kubun2"]."'"; }else{ $sql = " and kubun1 = '".$_REQUEST["kubun1"]."' and kubun3 >= '4'"; } $sql3 = " order by kubun3,kakaku_amt"; }else{ if($_REQUEST["kubun2"]){ $sql = " and kubun1 = '".$_REQUEST["kubun1"]."' and kubun3 = '".$_REQUEST["kubun2"]."'"; }else{ $sql = " and kubun1 = '".$_REQUEST["kubun1"]."' and kubun3 <= '3'"; } $sql3 = " order by kubun3,kakaku_amt"; } }else{ if($_REQUEST["kubun2"]){ $sql = " and kubun1 = '".$_REQUEST["kubun1"]."' and kubun2 = '".$_REQUEST["kubun2"]."'"; }else{ $sql = " and kubun1 = '".$_REQUEST["kubun1"]."'"; } $sql3 = " order by kubun1,kubun2,kakaku_amt"; } //echo "select * from ".$DB_vt_name." where vender_id = '".$_REQUEST["gyo"]."'".$sql.$sql3; if(!$listname[$_REQUEST["kubun1"].$_REQUEST["kubun2"]]){ echo "該当ページは存在しておりません、アクセスページをご確認ください。"; exit; } ?>