카테고리 문제인데요 채택완료
헤드 메뉴부분에 보이는 SHOP / 키즈&쥬니어 가 따로있는데
각각 메뉴로 눌러 들어가면 내용 왼쪽사이드에 보이는 메뉴에 샵이랑 키즈쥬니어가 같이나타나서요 ㅠㅠ
shop을 누르면 shop만, 키즈쥬니어를 누르면 키즈쥬니어만 떴으면 하는데
제가 작업한게 아니라 어떻게 수정을 해야할지 잘 모르겠어요 ㅠㅠ
작업자분한테 연락했더니 listcategory.skin 여기서 수정하셨다고 하는데 긁어오신거라 잘모른다고 하셔서요
어떤걸 수정해야 하나만 뜰까요?
</p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, "Courier New", monospace; font-size: 14px; line-height: 19px; white-space: pre;">
<div><span style="color: #569cd6;"><?php</span></div><div><span style="color: #c586c0;">if</span> (!<span style="color: #dcdcaa;">defined</span>(<span style="color: #ce9178;">"_GNUBOARD_"</span>)) <span style="color: #c586c0;">exit</span>; <span style="color: #608b4e;">// 개별 페이지 접근 불가</span></div>
<div><span style="color: #9cdcfe;">$str</span> = <span style="color: #ce9178;">''</span>;</div><div><span style="color: #9cdcfe;">$exists</span> = <span style="color: #569cd6;">false</span>;</div>
<div><span style="color: #9cdcfe;">$depth2_ca_id</span> = <span style="color: #dcdcaa;">substr</span>(<span style="color: #9cdcfe;">$ca_id</span>, <span style="color: #b5cea8;">0</span>, <span style="color: #b5cea8;">2</span>);</div>
<div><span style="color: #9cdcfe;">$sql</span> = <span style="color: #ce9178;">" select ca_id, ca_name from {</span><span style="color: #9cdcfe;">$g5</span><span style="color: #ce9178;">['g5_shop_category_table']} where ca_id like '</span><span style="color: #9cdcfe;">${depth2_ca_id}</span><span style="color: #ce9178;">%' and length(ca_id) = 4 and ca_use = '1' order by ca_order, ca_id "</span>;</div><div><span style="color: #9cdcfe;">$result</span> = <span style="color: #dcdcaa;">sql_query</span>(<span style="color: #9cdcfe;">$sql</span>);</div><div><span style="color: #c586c0;">while</span> (<span style="color: #9cdcfe;">$row</span>=<span style="color: #dcdcaa;">sql_fetch_array</span>(<span style="color: #9cdcfe;">$result</span>)) {</div><div> <span style="color: #c586c0;">if</span> (<span style="color: #dcdcaa;">preg_match</span>(<span style="color: #d16969;">"/</span>^<span style="color: #d16969;">{</span><span style="color: #9cdcfe;">$row</span><span style="color: #d16969;">[</span><span style="color: #ce9178;">'ca_id'</span><span style="color: #d16969;">]}/"</span>, <span style="color: #9cdcfe;">$ca_id</span>))</div><div> <span style="color: #9cdcfe;">$sct_ct_here</span> = <span style="color: #ce9178;">'sct_ct_here'</span>;</div><div> <span style="color: #c586c0;">else</span></div><div> <span style="color: #9cdcfe;">$sct_ct_here</span> = <span style="color: #ce9178;">''</span>;</div><div> <span style="color: #9cdcfe;">$str</span> .= <span style="color: #ce9178;">'<li><a href="./list.php?ca_id='</span>.<span style="color: #9cdcfe;">$row</span>[<span style="color: #ce9178;">'ca_id'</span>].<span style="color: #ce9178;">'" class="'</span>.<span style="color: #9cdcfe;">$sct_ct_here</span>.<span style="color: #ce9178;">'">'</span>.<span style="color: #9cdcfe;">$row</span>[<span style="color: #ce9178;">'ca_name'</span>].<span style="color: #ce9178;">'</a></li>'</span>;</div><div> <span style="color: #9cdcfe;">$exists</span> = <span style="color: #569cd6;">true</span>;</div><div>}</div>
<div><span style="color: #c586c0;">if</span> (<span style="color: #9cdcfe;">$exists</span>) {</div>
<div> <span style="color: #608b4e;">// add_stylesheet('css 구문', 출력순서); 숫자가 작을 수록 먼저 출력됨</span></div><div> <span style="color: #dcdcaa;">add_stylesheet</span>(<span style="color: #ce9178;">'<link rel="stylesheet" href="'</span>.G5_SHOP_CSS_URL.<span style="color: #ce9178;">'/style.css">'</span>, <span style="color: #b5cea8;">0</span>);</div><div><span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span></div>
<div><span style="color: #608b4e;"><!-- 상품분류 3 시작 { --></span></div><div><span style="color: #808080;"><</span><span style="color: #569cd6;">aside</span> <span style="color: #9cdcfe;">id</span>=<span style="color: #ce9178;">"sct_ct_2"</span> <span style="color: #9cdcfe;">class</span>=<span style="color: #ce9178;">"sct_ct"</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">table</span> <span style="color: #9cdcfe;">cellpadding</span>=<span style="color: #ce9178;">"0"</span> <span style="color: #9cdcfe;">cellspacing</span>=<span style="color: #ce9178;">"0"</span> <span style="color: #9cdcfe;">border</span>=<span style="color: #ce9178;">"0"</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">tr</span><span style="color: #808080;">></span> </div><div> <span style="color: #569cd6;"><?php</span></div><div> <span style="color: #608b4e;">// 1단계 분류 판매 가능한 것만</span></div><div> <span style="color: #9cdcfe;">$hsql</span> = <span style="color: #ce9178;">" select ca_id, ca_name from {</span><span style="color: #9cdcfe;">$g5</span><span style="color: #ce9178;">['g5_shop_category_table']} where length(ca_id) = '2' and ca_use = '1' order by ca_order, ca_id "</span>;</div><div> <span style="color: #9cdcfe;">$hresult</span> = <span style="color: #dcdcaa;">sql_query</span>(<span style="color: #9cdcfe;">$hsql</span>);</div><div> <span style="color: #9cdcfe;">$gnb_zindex</span> = <span style="color: #b5cea8;">999</span>; <span style="color: #608b4e;">// gnb_1dli z-index 값 설정용</span></div><div> <span style="color: #c586c0;">for</span> (<span style="color: #9cdcfe;">$i</span>=<span style="color: #b5cea8;">0</span>; <span style="color: #9cdcfe;">$row</span>=<span style="color: #dcdcaa;">sql_fetch_array</span>(<span style="color: #9cdcfe;">$hresult</span>); <span style="color: #9cdcfe;">$i</span>++)</div><div> {</div><div> <span style="color: #9cdcfe;">$gnb_zindex</span> -= <span style="color: #b5cea8;">1</span>; <span style="color: #608b4e;">// html 구조에서 앞선 gnb_1dli 에 더 높은 z-index 값 부여</span></div><div> <span style="color: #608b4e;">// 2단계 분류 판매 가능한 것만</span></div><div> <span style="color: #9cdcfe;">$sql2</span> = <span style="color: #ce9178;">" select ca_id, ca_name from {</span><span style="color: #9cdcfe;">$g5</span><span style="color: #ce9178;">['g5_shop_category_table']} where LENGTH(ca_id) = '4' and SUBSTRING(ca_id,1,2) = '{</span><span style="color: #9cdcfe;">$row</span><span style="color: #ce9178;">['ca_id']}' and ca_use = '1' order by ca_order, ca_id "</span>;</div><div> <span style="color: #9cdcfe;">$result2</span> = <span style="color: #dcdcaa;">sql_query</span>(<span style="color: #9cdcfe;">$sql2</span>);</div><div> <span style="color: #9cdcfe;">$count</span> = <span style="color: #dcdcaa;">sql_num_rows</span>(<span style="color: #9cdcfe;">$result2</span>);</div><div> <span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">td</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">a</span> <span style="color: #9cdcfe;">class</span>=<span style="color: #ce9178;">"cate_t_01"</span> <span style="color: #9cdcfe;">style</span>=<span style="color: #ce9178;">"color:#000000;"</span><span style="color: #808080;">></span><span style="color: #569cd6;"><?php</span> <span style="color: #dcdcaa;">echo</span> <span style="color: #9cdcfe;">$row</span>[<span style="color: #ce9178;">'ca_name'</span>]; <span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span><span style="color: #808080;"></</span><span style="color: #569cd6;">a</span><span style="color: #808080;">></span></div><div> <span style="color: #569cd6;"><?php</span></div><div> <span style="color: #c586c0;">for</span> (<span style="color: #9cdcfe;">$j</span>=<span style="color: #b5cea8;">0</span>; <span style="color: #9cdcfe;">$row2</span>=<span style="color: #dcdcaa;">sql_fetch_array</span>(<span style="color: #9cdcfe;">$result2</span>); <span style="color: #9cdcfe;">$j</span>++)</div><div> {</div><div> <span style="color: #c586c0;">if</span> (<span style="color: #9cdcfe;">$j</span>==<span style="color: #b5cea8;">0</span>) <span style="color: #dcdcaa;">echo</span> <span style="color: #ce9178;">'<ul class="cate_t_01" style="z-index:'</span>.<span style="color: #9cdcfe;">$gnb_zindex</span>.<span style="color: #ce9178;">'">'</span>;</div><div> <span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span></div><div> </div><div> <span style="color: #569cd6;"><?php</span> }</div><div> <span style="color: #c586c0;">if</span> (<span style="color: #9cdcfe;">$j</span>><span style="color: #b5cea8;">0</span>) <span style="color: #dcdcaa;">echo</span> <span style="color: #ce9178;">'</ul>'</span>;</div><div> <span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span></div>
<div> <span style="color: #569cd6;"><?php</span> } <span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span></div><div> <span style="color: #808080;"></</span><span style="color: #569cd6;">td</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"></</span><span style="color: #569cd6;">tr</span><span style="color: #808080;">></span></div><div><span style="color: #808080;"></</span><span style="color: #569cd6;">table</span><span style="color: #808080;">></span></div><div> <span style="color: #608b4e;"><!-- <table cellpadding="0" cellspacing="0"></span></div><div><span style="color: #608b4e;"> <tr></span></div><div><span style="color: #608b4e;"> <td class="cate_t_01"></span><span style="color: #569cd6;"><?php</span><span style="color: #608b4e;"> </span><span style="color: #dcdcaa;">echo</span><span style="color: #608b4e;"> </span><span style="color: #9cdcfe;">$ca</span><span style="color: #608b4e;">[</span><span style="color: #ce9178;">'ca_name'</span><span style="color: #608b4e;">]; </span><span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span><span style="color: #608b4e;"></td></span></div><div><span style="color: #608b4e;"> </tr></span></div><div><span style="color: #608b4e;"> </table> --></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">ul</span><span style="color: #808080;">></span></div><div> <span style="color: #569cd6;"><?php</span> <span style="color: #dcdcaa;">echo</span> <span style="color: #9cdcfe;">$str</span>; <span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span></div><div> <span style="color: #808080;"></</span><span style="color: #569cd6;">ul</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">table</span> <span style="color: #9cdcfe;">cellpadding</span>=<span style="color: #ce9178;">"0"</span> <span style="color: #9cdcfe;">cellspacing</span>=<span style="color: #ce9178;">"0"</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">tr</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"><</span><span style="color: #569cd6;">td</span> <span style="color: #9cdcfe;">class</span>=<span style="color: #ce9178;">"cate_t_02"</span><span style="color: #808080;">><</span><span style="color: #569cd6;">a</span> <span style="color: #9cdcfe;">href</span>=<span style="color: #ce9178;">"</span><span style="color: #569cd6;"><?php</span><span style="color: #ce9178;"> </span><span style="color: #dcdcaa;">echo</span><span style="color: #ce9178;"> G5_SHOP_URL; </span><span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span><span style="color: #ce9178;">/personalpay.php"</span><span style="color: #808080;">></span>개인결제<span style="color: #808080;"></</span><span style="color: #569cd6;">td</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"></</span><span style="color: #569cd6;">tr</span><span style="color: #808080;">></span></div><div> <span style="color: #808080;"></</span><span style="color: #569cd6;">table</span><span style="color: #808080;">></span></div><div> </div><div><span style="color: #808080;"></</span><span style="color: #569cd6;">aside</span><span style="color: #808080;">></span></div><div><span style="color: #608b4e;"><!-- } 상품분류 3 끝 --></span></div>
<div><span style="color: #569cd6;"><?php</span> } <span style="color: #569cd6;">?</span><span style="color: #569cd6;">></span></div></div><p>
</p><p>
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
채택된 답변
+20 포인트
8년 전
다시보니 그게 아니고 쿼리를 좀 수정하셔야 겠네요..
$sql = " select ca_id, ca_name from {$g5['g5_shop_category_table']} where ca_id =$ca_id and length(ca_id) = 4 and ca_use = '1' order by ca_order, ca_id ";
로그인 후 평가할 수 있습니다
답변에 대한 댓글 2개
�
8년 전
db 를 볼수 있으면 쉬운데 ^^ (제가 DB는 좀 합니다. ㅋㅋ)
select * from g5_shop_category 결과랑 $ca_id 만 확인되면 확실한 답을 드릴수 있을거 같네요 ^^
select * from g5_shop_category 결과랑 $ca_id 만 확인되면 확실한 답을 드릴수 있을거 같네요 ^^
댓글을 작성하려면 로그인이 필요합니다.
8년 전
$str .= '$row['ca_id'].'" class="'.$sct_ct_here.'">'.$row['ca_name'].'';
여기를
$str = '$row['ca_id'].'" class="'.$sct_ct_here.'">'.$row['ca_name'].'';
로 바꾸면 안될까요?
로그인 후 평가할 수 있습니다
답변에 대한 댓글 2개
�
8년 전
헉.. 그렇게 된걸 보니 ca_name 자체가 "SHOP 키즈& 주니어" 라고 되어 있나본데요?
관리자 메뉴에서 카테고리 네임을 먼저 확인해보세요 ^ ^
관리자 메뉴에서 카테고리 네임을 먼저 확인해보세요 ^ ^
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인전체 질문 목록
답변대기
채택
채택
채택
채택
채택
채택
답변대기
채택
채택
채택
답변대기
채택
채택
답변대기
채택
채택
채택
채택