최근게시물에서 첫번째 이미지가 아닌 두번째 이미지가 최근게시물에 나올수 있는 방법 문의드려요. 정보
최근게시물에서 첫번째 이미지가 아닌 두번째 이미지가 최근게시물에 나올수 있는 방법 문의드려요.본문
첫번째 이미지를 추출해서 뿌려주는데 두번째 이미지를 추출해서 뿌려주고 싶은데 어디를 고쳐야하나요?
<? for ($i=0; $i<count($list); $i++) { ?>
<?
if($list[$i]['file']['0']['view']) {
$src = $list[$i]['file']['0']['path']."/".$list[$i]['file']['0']['file'];
$thumb = thumbnail($src, $thumb_width, $thumb_height, 0, 1, $quality, 2, '', $filter, $noimg);
}else{
$edit_img = $list[$i]['wr_content'];
if (eregi("data/cheditor4[^<>]*\.(gif|jp[e]?g|png|bmp)", $edit_img, $tmp)) {
$file = $g4['path'].'/' . $tmp['0']; // 파일명
$thumb = thumbnail($file, $thumb_width, $thumb_height, 0, 1, $quality, 2, '', $filter, $noimg);
}
}
?>
<a href="<?=$thumb?>" rel="<?=$list[$i]['href']?>" target="_blank"><?=$list[$i]['subject']?></a>
<? } ?>
초짜라 참 어렵네요....
<? for ($i=0; $i<count($list); $i++) { ?>
<?
if($list[$i]['file']['0']['view']) {
$src = $list[$i]['file']['0']['path']."/".$list[$i]['file']['0']['file'];
$thumb = thumbnail($src, $thumb_width, $thumb_height, 0, 1, $quality, 2, '', $filter, $noimg);
}else{
$edit_img = $list[$i]['wr_content'];
if (eregi("data/cheditor4[^<>]*\.(gif|jp[e]?g|png|bmp)", $edit_img, $tmp)) {
$file = $g4['path'].'/' . $tmp['0']; // 파일명
$thumb = thumbnail($file, $thumb_width, $thumb_height, 0, 1, $quality, 2, '', $filter, $noimg);
}
}
?>
<a href="<?=$thumb?>" rel="<?=$list[$i]['href']?>" target="_blank"><?=$list[$i]['subject']?></a>
<? } ?>
초짜라 참 어렵네요....
( 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 = '249815' 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