$boardidx=1;//뽑고자 하는 게시판의 IDX값 $limitNum =5;//뽑고자하는 게시물 수 $bbsListRow = mysql_fetch_array(mysql_query("SELECT * FROM bbs_list WHERE idx=$boardIndex")); $numResult=mysql_query("SELECT idx FROM bbs_data WHERE code='$bbsListRow[code]' ORDER BY idx DESC LIMIT $limitNum"); $numRow=mysql_num_rows($numResult); if(!$letter_no) { $letter_no = $numRow; } $bbsQry = "SELECT * FROM bbs_data WHERE code='$bbsListRow[code]' ORDER BY ref desc,re_step ASC LIMIT $limitNum"; $bbsResult=mysql_query($bbsQry); while($bbsRow=mysql_fetch_array($bbsResult)) { $encode_str = "idx=".$bbsRow[idx]."pagecnt=".$pagecnt."letter_no=".$s_letter."offset=".$offset; $encode_str.= "search=".$search."searchstring=".$searchstring."present_num=".$letter_no; $data=Encode64($encode_str); //새글이미지 if(BetweenPeriod($bbsRow[writeday],1) 0) $newImg = "img src='image/icon/icon_new.gif' width='30' height='10'"; else $newImg = ""; echo $bbsListRow[name];// 게시판이름
if ($newImg) $title_width = (42/$design[community_cols]); else $title_width = (60/$design[community_cols]);
//잠금글이거나 회원 등급에 권한 링크 if ($bbsRow[bLock]=="y") echo "a href='board_lock.php?data=$databoardIndex=$boardidx'"; else if($row[rAct]==0 || ($row[rAct]=$GOOD_SHOP_LEVEL)) echo "a href='board_view.php?data=$databoardIndex=$boardidx'"; else echo "a href='#;' onclick='javascript:readLoginErr();'"; echo StringCut($bbsRow[title],Round($title_width)) ."/a".$newImg;// 타이틀 출력 echo substr($bbsRow[writeday],2,8);//날짜 출력 }
위 형태로 불러오시면 됩니다. |