ドラムスが選択されました --- "; } if($s_mode == 'gr002'){ $group = "スネアが選択されました --- "; } if($s_mode == 'gr003'){ $group = "シンバルが選択されました --- "; } if($s_mode == 'gr004'){ $group = "ハードウエアが選択されました --- "; } if($s_mode == 'gr005'){ $group = "パーカッションが選択されました --- "; } //====================機材選択ボタン色設定 if($s_mode == 'gr001'){ $btn1 = "class='crbtnred'"; }else{ $btn1 = "class='crbtn'"; } if($s_mode == 'gr002'){ $btn2 = "class='crbtnred'"; }else{ $btn2 = "class='crbtn'"; } if($s_mode == 'gr003'){ $btn3 = "class='crbtnred'"; }else{ $btn3 = "class='crbtn'"; } if($s_mode == 'gr004'){ $btn4 = "class='crbtnred'"; }else{ $btn4 = "class='crbtn'"; } if($s_mode == 'gr005'){ $btn5 = "class='crbtnred'"; }else{ $btn5 = "class='crbtn'"; } //====================ラジオ・セレクト初期設定設定 //----------年代 if($rg_agectg == ""){ $age_nl = "selected"; }else{ $age_nl = ""; } if($rg_agectg == "70"){ $age_70 = "selected"; }else{ $age_70 = ""; } if($rg_agectg == "80"){ $age_80 = "selected"; }else{ $age_80 = ""; } //----------機材 if($rg_grpcde == "gr001"){$gr1 = "checked";}else{$gr1 = "";} if($rg_grpcde == "gr002"){$gr2 = "checked";}else{$gr2 = "";} if($rg_grpcde == "gr003"){$gr3 = "checked";}else{$gr3 = "";} if($rg_grpcde == "gr004"){$gr4 = "checked";}else{$gr4 = "";} if($rg_grpcde == "gr005"){$gr5 = "checked";}else{$gr5 = "";} //----------ドラム材質 if($sr_mtrnkj == ""){$sel_dm_df = "selected";}else{$sel_dm_df = "";} //----------スネア材質 if($rg_mtrnkj == ""){$sel_sn_df = "selected";}else{$sel_sn_df = "";} //---------- if($rg_snrsiz == ""){$ss0 = "selected";}else{$ss0 = "";} if($rg_snrsiz == "深さ 5インチ未満"){$ss1 = "selected";}else{$ss1 = "";} if($rg_snrsiz == "深さ 5〜5．5インチ"){$ss2 = "selected";}else{$ss2 = "";} if($rg_snrsiz == "深さ 6インチ以上"){$ss3 = "selected";}else{$ss3 = "";} if($rg_snrsiz == "口径 13インチ以下"){$ss4 = "selected";}else{$ss4 = "";} //====================select設定 //__________メーカー：ドラムス $sql_mk_dr = "select rg_mkrcde,rg_mkrneg,rg_grpcde from rentalgoods_tb where rg_grpcde = \"gr001\" and rg_sttchk = \"on\" group by rg_mkrcde order by rg_mkrcde"; $res_mk_dr = mysql_query($sql_mk_dr); $opt_mk_dr = ""; while($row_mk_dr = mysql_fetch_array($res_mk_dr)){ if($row_mk_dr['rg_mkrcde'] == $rg_mkrcde){$selected = "selected";}else{$selected = "";} $opt_mk_dr .= "\n"; } //__________メーカー：スネア $sql_mk_sn = "select rg_mkrcde,rg_mkrneg,rg_grpcde from rentalgoods_tb where rg_grpcde = \"gr002\" and rg_sttchk = \"on\" group by rg_mkrcde order by rg_mkrcde"; $res_mk_sn = mysql_query($sql_mk_sn); $opt_mk_sn = ""; while($row_mk_sn = mysql_fetch_array($res_mk_sn)){ if($row_mk_sn['rg_mkrcde'] == $rg_mkrcde){$selected = "selected";}else{$selected = "";} $opt_mk_sn .= "\n"; } //__________メーカー：シンバル $sql_mk_cy = "select rg_mkrcde,rg_mkrneg,rg_grpcde from rentalgoods_tb where rg_grpcde = \"gr003\" and rg_sttchk = \"on\" group by rg_mkrcde order by rg_mkrcde"; $res_mk_cy = mysql_query($sql_mk_cy); $opt_mk_cy = ""; while($row_mk_cy = mysql_fetch_array($res_mk_cy)){ if($row_mk_cy['rg_mkrcde'] == $rg_mkrcde){$selected = "selected";}else{$selected = "";} $opt_mk_cy .= "\n"; } //__________メーカー：ハードウエア $sql_mk_hw = "select rg_mkrcde,rg_mkrneg,rg_grpcde from rentalgoods_tb where rg_grpcde = \"gr004\" and rg_sttchk = \"on\" group by rg_mkrcde order by rg_mkrcde"; $res_mk_hw = mysql_query($sql_mk_hw); $opt_mk_hw = ""; while($row_mk_hw = mysql_fetch_array($res_mk_hw)){ if($row_mk_hw['rg_mkrcde'] == $rg_mkrcde){$selected = "selected";}else{$selected = "";} $opt_mk_hw .= "\n"; } //__________メーカー：パーカッション $sql_mk_pr = "select rg_mkrcde,rg_mkrneg,rg_grpcde from rentalgoods_tb where rg_grpcde = \"gr005\" and rg_sttchk = \"on\" group by rg_mkrcde order by rg_mkrcde"; $res_mk_pr = mysql_query($sql_mk_pr); $opt_mk_pr = ""; while($row_mk_pr = mysql_fetch_array($res_mk_pr)){ if($row_mk_pr['rg_mkrcde'] == $rg_mkrcde){$selected = "selected";}else{$selected = "";} $opt_mk_pr .= "\n"; } if($s_mode != ""){ $opt_mk = "\n"; break; case "gr002": //__________スネア $opt_mk .= $opt_mk_sn; $opt_mk .= "\n"; break; case "gr003": //__________シンバル $opt_mk .= $opt_mk_cy; $opt_mk .= "\n"; break; case "gr004": //__________ハードウエア $opt_mk .= $opt_mk_hw; $opt_mk .= "\n"; break; case "gr005": //__________パーカッション $opt_mk .= $opt_mk_pr; $opt_mk .= "\n"; break; default: //__________デフォルト $opt_mk .= "\n"; $opt_mk .= $opt_mk_dr; $opt_mk .= "\n"; $opt_mk .= "\n"; $opt_mk .= $opt_mk_sn; $opt_mk .= "\n"; $opt_mk .= "\n"; $opt_mk .= $opt_mk_cy; $opt_mk .= "\n"; $opt_mk .= "\n"; break; } }else{ $opt_mk = ""; } //__________年代分類検索 if($s_mode != ""){ $opt_ag = "\n"; }else{ $opt_ag = ""; } //__________ドラムシェル材質 $sql_sl_mtrdr = "select sr_mtrnkj,sr_sttchk from series_tb where sr_sttchk = \"on\" and sr_mtrnkj <> \"\" group by sr_mtrnkj order by sr_mtrnkj"; $res_sl_mtrdr = mysql_query($sql_sl_mtrdr); $a = ""; while($row_sl_mtrdr = mysql_fetch_array($res_sl_mtrdr)){ $a .= $row_sl_mtrdr['sr_mtrnkj'] . "／"; } $b = explode('／',$a); $c = array_unique($b); asort($c); $opt_mt_dr = ""; foreach($c as $element){ if($element != ""){ if($sr_mtrnkj == $element){ $sel_dm = "selected"; }else{ $sel_dm = ""; } $opt_mt_dr .= "\n"; } } if($s_mode == 'gr001'){ $sel_mt_dr = "\n"; }else{ if($s_mode == ""){ $sel_mt_dr = ""; }else{ $sel_mt_dr = "選択できません"; } } //__________スネアシェル材質 $sql_sl_mtrsn = "select rg_grpcde,rg_mtrnkj,rg_sttchk from rentalgoods_tb where rg_grpcde = \"gr002\" and rg_sttchk = \"on\" and rg_mtrnkj <> \"\" group by rg_mtrnkj order by rg_mtrnkj"; $res_sl_mtrsn = mysql_query($sql_sl_mtrsn); $e = ""; while($row_sl_mtrsn = mysql_fetch_array($res_sl_mtrsn)){ $e .= $row_sl_mtrsn['rg_mtrnkj'] . "／"; } $f = explode('／',$e); $g = array_unique($f); asort($g); $result = array_shift($g); array_splice($g,count($g),0,array($result)); $opt_sl_mtrsn = ""; foreach($g as $element2){ if($element2 != ""){ if($rg_mtrnkj == $element2){ $sel_sn = "selected"; }else{ $sel_sn = ""; } $opt_sl_mtrsn .= "\n"; } } if($s_mode == "gr002"){ $sel_mt_sn = "\n"; }else{ if($s_mode == ""){ $sel_mt_sn = ""; }else{ $sel_mt_sn = "選択できません"; } } //__________シンバルサイズ $sql_cy_sz = "select rg_grpcde,rg_size_w,rg_sttchk from rentalgoods_tb where rg_grpcde = \"gr003\" and rg_sttchk = \"on\" and rg_size_w <> 0 group by rg_size_w order by rg_size_w"; $res_cy_sz = mysql_query($sql_cy_sz); $opt_cy_sz = ""; while($row_cy_sz = mysql_fetch_array($res_cy_sz)){ if(strlen(strval($row_cy_sz['rg_size_w'])) == 1){ $sp = " "; }else{ $sp = ""; } if($row_cy_sz['rg_size_w'] == $rg_size_w){$selected = "selected";}else{$selected = "";} $opt_cy_sz .= "\n"; } if($s_mode == 'gr003'){ $sel_cy_sz = "\n"; }else{ if($s_mode == ""){ $sel_cy_sz = ""; }else{ $sel_cy_sz = "選択できません"; } } //__________ドラムフープ $sql_hp_dr = "select rg_grpcde,rg_hopgrp,rg_sttchk from rentalgoods_tb where rg_grpcde = \"gr001\" and rg_sttchk = \"on\" and rg_hopgrp <> \"\" group by rg_hopgrp order by rg_hopgrp"; $res_hp_dr = mysql_query($sql_hp_dr); $opt_hp_dr = ""; while($row_hp_dr = mysql_fetch_array($res_hp_dr)){ if($rg_grpcde == "gr001" && $row_hp_dr['rg_hopgrp'] == $rg_hopgrp){$selected = "selected";}else{$selected = "";} $opt_hp_dr .= "