3차메뉴 쿼리적용하는 방법부탁드립니다..ㅠ 채택완료
</p><p> <div id="aside"></p><p> <dl></p><p> <dt><h3><?php echo $me_gr_name ?></h3></dt></p><p> <?php</p><p> $sql = " select * from {$g5['menu_table']} where me_code like '$me_gr_code%' and length(me_code) = '4' order by me_code ";</p><p> $result = sql_query($sql);</p><p> </p><p> for ($bi=0; $row=sql_fetch_array($result); $bi++) { // bi 는 board index</p><p> ?></p><p> <dd><a href="<?php echo $row['me_link'] ?>"><?php echo $row['me_name']?></a></dd></p><p> <?php } ?></p><p> </dl></p><p> </div></p><p>
복스리님께서 도움을 주셨는데 어디디에 삽입해야 될지 모르겠어서...
질문드립니다.
구성된 쿼리를 어다 집어넣어야 되나요..?
</span></p><p><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"> $sql3 = " select *</span><br style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"> from {$g5['menu_table']}</span><br style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"> where me_use = '1'</span><br style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"> and length(me_code) = '6'</span><br style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"> and substring(me_code, 1, 4) = '{$row2['me_code']}'</span><br style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"> order by me_order, me_id ";</span><br style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;"> $result3 = sql_query($sql3); </span> </p><p><span style="color: rgb(80, 80, 80); font-family: 돋움, Dotum, sans-serif; font-size: 14.004px; line-height: 25.2072px;">
특정그룹에만 넣으려는데 조건문은 어떻게 만들어할까요..
도움부탁드립니다...
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인