묻고답하기
이미지 추가
2012.09.12 02:46
첨부파일에 내용처럼 하려면 어떻게 해야 하나요?
<title>운영진경매방</title>
<table width="600" cellpadding="0" cellspacing="0" border="0">
<td valign="top"><table width="318" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><a href="/bbs/board.php?bo_table=nan01"><img src="/images/img_04-5.gif" border="0" /></a></td>
</tr>
<tr height="10"></tr>
<tr>
<td><table border="0" cellpadding="0" cellspacing="0">
<?
$qry = "SELECT * FROM g4_board WHERE bo_table = 'nan01'";
$result = mysql_query($qry);
$row = mysql_fetch_array($result);
$bo_notice = explode("\n",$row[bo_notice]);
$size_notice = sizeof($bo_notice) - 1;
for($i = 0; $i < $size_notice; $i ++){
if($size_notice == 1) {
$wh = "and wr_id != '$bo_notice[$i]'";
continue;
} else {
$wh .= " and wr_id != '$bo_notice[$i]'";
}
}
$querya = "SELECT * FROM g4_write_nan01 WHERE wr_subject != '' $wh ORDER BY wr_id DESC Limit 0,3";
$resulta = sql_query($querya);
$i = 0;
$list = mysql_fetch_array($resulta);
$queryb = sql_query("SELECT * FROM g4_board_file WHERE bo_table = 'nan01' and wr_id = '$list[0]' ORDER BY bf_no ASC Limit 0,1");
$dataa = mysql_fetch_array($queryb);
?>
<tr height="139">
<td width="160" bgcolor="#E7E6E6" align="center"><a href="/bbs/board.php?bo_table=nan01&wr_id=<?=$list[wr_id]?>">
<?=get_smallimg_in_list('nan01', $dataa[bf_file], 0, 160, 139, '/images/noimage.gif', '', 'width',4)?>
</a></td>
<td width="9"></td>
<td width="280" valign="top" style="padding-top:6px;"><a href="/bbs/board.php?bo_table=nan01&wr_id=<?=$list[wr_id]?>" class="e"><b>
<?=cut_str($list[wr_subject],30,"..")?>
</b></a>
<? if ($list[wr_comment] != 0) echo " <span style='font-family:Tahoma;font-size:10px;color:red;'>[{$list[wr_comment]}]</span>";?>
<img src="/images/new.gif" border="0" align="absmiddle" />
<div style="padding-top:8px;"> <font color="#5D5C5C">
<?=cut_str(strip_tags($list[wr_content]),100,"…")?>
</font> </div>
<div style="padding-bottom:8px;padding-top:8px;"><img src="/images/line-1.gif" border="0" /></div>
<img src="/images/name.gif" border="0" align="absmiddle" /> <font color="#5D5C5C">
<?=$list[wr_name]?>
</font> <br />
<img src="/images/date.gif" border="0" align="absmiddle" /> <font color="#5D5C5C">
<?=substr($list[wr_last],0,10)?>
</font> </td>
<td width="32"> </td>
<td width="5"><img src="/images/img_02-1.gif" border="0" /></td>
<td width="32"> </td>
<td></td>
<?
$qry = "SELECT * FROM g4_board WHERE bo_table = 'nan01'";
$result = mysql_query($qry);
$row = mysql_fetch_array($result);
$bo_notice = explode("\n",$row[bo_notice]);
$size_notice = sizeof($bo_notice) - 1;
for($i = 0; $i < $size_notice; $i ++){
if($size_notice == 1) {
$wh = "and wr_id != '$bo_notice[$i]'";
continue;
} else {
$wh .= " and wr_id != '$bo_notice[$i]'";
}
}
$querya = "SELECT * FROM g4_write_nan01 WHERE wr_subject != '' $wh ORDER BY wr_id DESC Limit 1,1";
$resulta = sql_query($querya);
$i = 0;
$list = mysql_fetch_array($resulta);
$queryb = sql_query("SELECT * FROM g4_board_file WHERE bo_table = 'nan01' and wr_id = '$list[0]' ORDER BY bf_no ASC Limit 0,1");
$dataa = mysql_fetch_array($queryb);
?>
<td height="139">
<td width="160" bgcolor="#E7E6E6" align="center"><a href="/bbs/board.php?bo_table=nan01&wr_id=<?=$list[wr_id]?>">
<?=get_smallimg_in_list2('nan01', $dataa[bf_file], 0, 160, 139, '/images/noimage.gif', '', 'width',4)?>
</a></td>
<td width="9"></td>
<td width="280" valign="top" style="padding-top:6px;"><a href="/bbs/board.php?bo_table=nan01&wr_id=<?=$list[wr_id]?>" class="e"><b>
<?=cut_str($list[wr_subject],30,"..")?>
</b></a>
<? if ($list[wr_comment] != 0) echo " <span style='font-family:Tahoma;font-size:10px;color:red;'>[{$list[wr_comment]}]</span>";?>
<img src="/images/new.gif" border="0" align="absmiddle" />
<div style="padding-top:8px;"> <font color="#5D5C5C">
<?=cut_str(strip_tags($list[wr_content]),100,"…")?>
</font> </div>
<div style="padding-bottom:8px;padding-top:8px;"><img src="/images/line-1.gif" border="0" /></div>
<img src="/images/name.gif" border="0" align="absmiddle" /> <font color="#5D5C5C">
<?=$list[wr_name]?>
</font> <br />
<img src="/images/date.gif" border="0" align="absmiddle" /> <font color="#5D5C5C">
<?=substr($list[wr_last],0,10)?>
</font> </td>
</td>
</table></td>
</tr>
</table></td></tr>
</table>
