http://sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=69789

곰순이푸 님의 랜덤게시판 입니다.

1개만 랜덤으로 출력하는데 2개 3개 랜덤으로 출력하는 방법을 모르겠습니다 ㅠ 도와주세요

가로로 3개 랜덤으로 출력하는 방법좀 알려주세요

banner.php 파일 첨부하겠습니다

[code]<?
$banner_hit = 10000; // 노출 횟수

// 포인트 배너광고
$banner_table = "B13"; //배너 게시판 테이블
$sql = " select wr_id, wr_subject, mb_id, wr_1, wr_2, wr_hit from {$g4[write_prefix]}{$banner_table}
where wr_is_comment = '0'
and wr_1 = ''
and wr_hit < '".($banner_hit+1)."'
order by rand() limit 1 ";
$row = sql_fetch($sql);

$sql3 = " select bo_1 from {$g4[board_table]}
where bo_table = '".$banner_table."' ";
$row3 = sql_fetch($sql3);

list($imgw, $imgh) = explode("x", $row3[bo_1]);

if ($row[mb_id])
{
$sql1 = " select mb_id ,mb_point from $g4[member_table]
where mb_id = '".$row[mb_id]."' ";
$row1 = sql_fetch($sql1);

$banner_point = 100; // 최저 포인트
if ($row1[mb_point] <= $banner_point)
sql_query(" update {$g4[write_prefix]}{$banner_table} set wr_1 = '중지' where wr_id = '$row[wr_id]' ");
}

if ($row[wr_id])
{
if ($row[wr_hit] >= $banner_hit)
sql_query(" update {$g4[write_prefix]}{$banner_table} set wr_1 = '종료' where wr_id = '$row[wr_id]' ");

$sql2 = " select bf_file from $g4[board_file_table]
where bo_table = '$banner_table'
and wr_id = '$row[wr_id]'
and bf_no = 0 ";
$row2= sql_fetch($sql2);
if ($row2[bf_file])
$banner_img = "$g4[path]/data/file/$banner_table/$row2[bf_file]";
else
$banner_img = "$g4[path]/img/banner01.gif";

$subj = get_text($row[wr_subject]);
$href = "$g4[bbs_path]/link.php?bo_table={$banner_table}&wr_id={$row[wr_id]}&no=1&id=point&mb_id={$row1[mb_id]}";
echo "<table cellpadding='0' cellspacing='0' border='0'>";
echo "<a href='$href' target='_blank' title='$subj'><img src='$banner_img' border='0' width='$imgw' height='$imgh' style='border:solid 0 #555555;'></a>";
echo "<tr><td height='2'></td></tr>";
echo "<tr><td height='16' align='left'><font color=#4f4f4f>{$subject}</td></tr>";
echo "<tr><td height='2'></td></tr>";
echo "<tr><td height='14' align='left'><img src='{$latest_skin_path}/img/b_productlist_price.gif' align=\"absmiddle\"> <span $style><font color=#FF9900>{$list[$i][wr_8]}원</span>    <span $style><font color=#4f4f4f>Hit : <B>{$list[$i][link_hit][1]}</font></B></span></td></tr>";
echo "<tr><td height='3'></td></tr>";
echo "<tr><td height='14' align='left'><img src='{$latest_skin_path}/img/i_home.gif' align=\"absmiddle\"> <a href=\"{$list[$i][wr_link2]}\" target=\"_blank\"<span $style><font color=#4f4f4f>{$list[$i][wr_7]}</span></a></td></tr>";
echo "<tr><td height='5'></td></tr>";
echo "</table>";
// View(Hit)
sql_query(" update {$g4[write_prefix]}{$banner_table} set wr_hit = wr_hit + 1 where wr_id = '$row[wr_id]' ");
}
?>
[/code]