4차 카테고리 레프트 메뉴 영카트로 만들어야하는데요~~ 정보
4차 카테고리 레프트 메뉴 영카트로 만들어야하는데요~~본문
4차 카테고리 레프트 메뉴 영카트로 만들어야하는데요~~
고수님들 도와주세요^^;;
<?
/* 쇼핑몰 상품페이지일때 */
if ($ca_id)
{
$str = $bar = "";
$len = strlen($ca_id) / 2;
for ($i=1; $i<=$len; $i++)
{
$code = substr($ca_id,0,$i*2);
$sql = " select ca_name from $g4[yc4_category_table] where ca_id = '$code' ";
$row = sql_fetch($sql);
$style = "";
if ($ca_id == $code)
$style = "style='font-weight:bold;'";
if($ca_id)
$str .= $bar . "<li class='Navi'><a href='./list.php?ca_id=$code' $style>$row[ca_name]</a></li>";
}?>
----------------------------------------------
현재 1차 카테고리로 만들었는데요
4차카테고리로 만들려면 어떻게 하면 좋을까요^^
고수님들 도와주세요^^;;
<?
/* 쇼핑몰 상품페이지일때 */
if ($ca_id)
{
$str = $bar = "";
$len = strlen($ca_id) / 2;
for ($i=1; $i<=$len; $i++)
{
$code = substr($ca_id,0,$i*2);
$sql = " select ca_name from $g4[yc4_category_table] where ca_id = '$code' ";
$row = sql_fetch($sql);
$style = "";
if ($ca_id == $code)
$style = "style='font-weight:bold;'";
if($ca_id)
$str .= $bar . "<li class='Navi'><a href='./list.php?ca_id=$code' $style>$row[ca_name]</a></li>";
}?>
----------------------------------------------
현재 1차 카테고리로 만들었는데요
4차카테고리로 만들려면 어떻게 하면 좋을까요^^
( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '268301' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )
1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
error file : /15sir/bbs/board.php