문의드립니다. 정보
문의드립니다.본문
안녕하세요^^ 다름이 아니라
최근게시몰이 기본 가로로 4개씩 나오는대 이걸 3개로 하고 싶거덩요 ㅠ
3개로 2줄로요
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$gr = get_group($gr_id);
?>
<table align="left" cellpadding="0" cellspacing="0" width="100%" border="0">
<? for ($i=0; $i<count($list); $i++) {?>
<tr>
<td width="1" bgcolor="#1c1c1c"></td>
<td width="1"></td>
<td height="21">
<table cellpadding=0 cellspacing=0>
<tr>
<?
for ($i=0; $i<count($list); $i++) {
$list[$i]['content']=eregi_replace(" "," ",$list[$i]['content']);
if($list[$i][file][0][file]) {
$file = "<img src='".$list[$i][file][0][path] .'/'. $list[$i][file][0][file]."' align=absmiddle width=\"80\" height=\"80\">";
} else {
$file="";
}
?>
<td align=center>
<table width="80px">
<tr>
<td width="80" height="40" ><a href="<?=$list[$i]['href']?>"><?=$file?></a></td>
</tr>
<tr>
<td><a href="<?=$list[$i]['href']?>"><?=$list[$i]['subject']?></a></td>
</tr>
<tr>
<td><a href="<?=$list[$i]['href']?>"><span style='color:#666666;'><?=conv_subject($list[$i]['content'], 65, $cutopt="...")?></span></a></td>
</tr>
</table>
</td>
<?if($i!=count($list)-1) { ?>
<? } ?>
<? } ?>
</tr>
<? if (count($list) == 0) { ?><tr><td colspan=4 align=center height=30><font color=#6A6A6A>게시물이 없습니다.</a></td></tr><? } ?>
</table>
</td>
<!--게시물 추출 글자 설정 끝-->
<td width="1" bgcolor="#1c1c1c"></td>
</tr>
<? } ?>
<? if (count($list) == 0) { ?><? } ?>
<tr height="1">
<td colspan="4"></td>
</tr>
</table>
이건데 어떻게 해야하나요?
최근게시몰이 기본 가로로 4개씩 나오는대 이걸 3개로 하고 싶거덩요 ㅠ
3개로 2줄로요
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$gr = get_group($gr_id);
?>
<table align="left" cellpadding="0" cellspacing="0" width="100%" border="0">
<? for ($i=0; $i<count($list); $i++) {?>
<tr>
<td width="1" bgcolor="#1c1c1c"></td>
<td width="1"></td>
<td height="21">
<table cellpadding=0 cellspacing=0>
<tr>
<?
for ($i=0; $i<count($list); $i++) {
$list[$i]['content']=eregi_replace(" "," ",$list[$i]['content']);
if($list[$i][file][0][file]) {
$file = "<img src='".$list[$i][file][0][path] .'/'. $list[$i][file][0][file]."' align=absmiddle width=\"80\" height=\"80\">";
} else {
$file="";
}
?>
<td align=center>
<table width="80px">
<tr>
<td width="80" height="40" ><a href="<?=$list[$i]['href']?>"><?=$file?></a></td>
</tr>
<tr>
<td><a href="<?=$list[$i]['href']?>"><?=$list[$i]['subject']?></a></td>
</tr>
<tr>
<td><a href="<?=$list[$i]['href']?>"><span style='color:#666666;'><?=conv_subject($list[$i]['content'], 65, $cutopt="...")?></span></a></td>
</tr>
</table>
</td>
<?if($i!=count($list)-1) { ?>
<? } ?>
<? } ?>
</tr>
<? if (count($list) == 0) { ?><tr><td colspan=4 align=center height=30><font color=#6A6A6A>게시물이 없습니다.</a></td></tr><? } ?>
</table>
</td>
<!--게시물 추출 글자 설정 끝-->
<td width="1" bgcolor="#1c1c1c"></td>
</tr>
<? } ?>
<? if (count($list) == 0) { ?><? } ?>
<tr height="1">
<td colspan="4"></td>
</tr>
</table>
이건데 어떻게 해야하나요?
( 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 = '252212' 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