아래 소스는 최저가경매를 조금 변형한 스킨에서 입찰내역 페이지인데요.

입찰수치를 클릭하면 작은 수부터 소팅될 수 있도록 어렵지 않으면 부탁드려봅니다~


--------------------------------------------------

<?
include_once("./_common.php");

$g4[title] = "응모내역";
include_once("$g4[path]/head.sub.php");

$ge_rows = sql_fetch(" select * from g4_event where ge_no='$ge_no' ");
if(!$is_admin && $ge_rows['ge_odate']>time()){alert_close('이벤트 발표일까지 열람하실수 없습니다.');}

//응답업데이트 안되었는지확인
if($ge_rows['ge_win']=="n"){
$geb_sql = " select * from g4_event_bid left join g4_event_auction on geb_no=gea_cno  where gea_pno='$ge_no' order by geb_count, gea_wdate limit 0, {$ge_rows['ge_bid_wcount']}";
$geb_result = sql_query($geb_sql);
$first_name = "";
$win_temp = 0;
while($geb_rows = sql_fetch_array($geb_result)){
sql_query(" update g4_event_auction set gea_win=1 where gea_no='{$geb_rows['gea_no']}' ");
if(!$first_name){ $first_name=$geb_rows['gea_nick']; }
$win_temp++;
}
$win_temp--;
if($win_temp>0){ $add_winer = "외 ".$win_temp."건"; $first_name .= $add_winer;}

sql_query(" update g4_event set ge_win='y', ge_winer='$first_name' where ge_no='$ge_no' ");
}

$list = array();

$sql_common = " from g4_event_bid left join g4_event_auction on geb_no=gea_cno  where gea_pno='$ge_no' ";
$sql_order = " order by geb_count, gea_wdate ";

$sql = " select count(*) as cnt $sql_common ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = $config[cf_page_rows];
$total_page  = ceil($total_count / 20);  // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * 20; // 시작 열을 구함

$list = array();

$sql = " select *
          $sql_common
          $sql_order
          limit $from_record, 20 ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
    $list[$i] = $row;

    // 순차적인 번호 (순번)
    $num =  ((($page - 1) * 20)+1) + $i;


    $list[$i][num] = $num;
    $list[$i][opener_href] = "./board.php?bo_table=$row[bo_table]";
    $list[$i][opener_href_wr_id] = "./board.php?bo_table=$row[bo_table]&wr_id=$row[wr_id]";
    $list[$i][bo_subject] = $row2[bo_subject];
    $list[$i][subject] = $subject;
    $list[$i][del_href] = "./scrap_delete.php?ms_id=$row[ms_id]&page=$page";
}
$qstr="&ge_no=$ge_no";
?>
<table width="100%" height="50" border="0" cellpadding="0" cellspacing="0">
<tr>
    <td align="center" valign="middle" bgcolor="#EBEBEB">
        <table width="100%" height="40" border="0" cellspacing="0" cellpadding="0" style="margin:4px;">
        <tr>
            <td width="25" align="center" bgcolor="#FFFFFF" ></td>
            <td width="75" align="left" bgcolor="#FFFFFF" ><font color="#666666"><b>응모내역</b></font></td>
            <td width="490" bgcolor="#FFFFFF" ></td>
        </tr>
        </table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td align="center" valign="top">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td height="20">
<div class="tar fs11 fwb c4">중복없이 가장 낮은 수로 입찰하신  <?=$ge_rows['ge_bid_wcount']?>명이 당첨자입니다.</div></td>
        </tr>
        <tr>
            <td height="2" bgcolor="#808080"></td>
        </tr>
        <tr>
            <td bgcolor="#FFFFFF">
                <table width=100% cellpadding=1 cellspacing=1 border=0>
                <tr bgcolor=#E1E1E1 align=center>
                    <td width="10%" height="24"><b>번호</b></td>
<td width="10%" height="24"><b>당첨</b></td>
                    <td width="20%"><b>입찰수치</b></td>
                    <td width="30%"><b>응모자</b></td>
                    <td width="30%"><b>응모일시</b></td>
                </tr>

                <? for ($i=0; $i<count($list); $i++) { ?>
                    <tr height=25 bgcolor="#F6F6F6" align="center">
                        <td height="24"><?=$list[$i][num]?></td>
<td><?if($list[$i][gea_win]==1) echo"-";?></td>
                        <td><?=$list[$i][gea_bnum]?></td>
                        <td><?=$list[$i][gea_nick]?></td>
                        <td><?=date('Y.m.d H:i:s', $list[$i][gea_wdate])?></td>
                    </tr>
                <? } ?>

                <? if ($i == 0) echo "<tr><td colspan=5 align=center height=100>자료가 없습니다.</td></tr>"; ?>
                </table></td>
        </tr>
        </table></td>
</tr>
<tr>
    <td height="30" align="center"><?=get_paging($config[cf_write_pages], $page, $total_page, "?page=", $qstr);?></td>
</tr>
</table>
<?if(($is_admin && $ge_rows['ge_win']=="y") || ($member['mb_no']==$ge_rows['ge_mno'] && $ge_rows['ge_win']=="y")){?>
<form name=fmemoform method=post onsubmit="return fmemoform_submit(this);" autocomplete="off">
<input type="hidden" name="ge_no" value="<?=$ge_no?>" />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td height="20" align="center" class="fwb">당첨회원에게 쪽지보내기</td>
        </tr>
        <tr>
            <td height="2" bgcolor="#808080"></td>
        </tr>
        <tr>
            <td height="140" align="center" valign="middle" bgcolor="#F6F6F6">
                <textarea name=me_memo rows=8 style='width:95%;' required itemname='내용'><?=$content?></textarea></td>
        </tr>
        <tr>
            <td>
                <table width=100% cellpadding=1 cellspacing=1 border=0>
                <tr align=center>
                    <td width="30%" height="24" rowspan="2"><img id='kcaptcha_image' /></td>
                    <td width="70%" align="left">
                        <input type=input size=10 name=wr_key itemname="자동등록방지" required>&nbsp;&nbsp;왼쪽의 글자를 입력하세요.
                    </td>
                </tr>
                </table>
            </td>
        </tr>
        </table>
<div class="tac">
<input id=btn_submit type=image src="<?=$g4[path]?>/skin/member/basic/img/btn_paper_send.gif" border=0>
</div>
</form>
</table>
<script type="text/javascript" src="<?=$g4[path]?>/js/md5.js"></script>
<script type="text/javascript" src="<?="$g4[path]/js/jquery.kcaptcha.js"?>"></script>
<script type="text/javascript">
function fmemoform_submit(f)
{
    if (!check_kcaptcha(f.wr_key)) {
        return false;
    }

    document.getElementById("btn_submit").disabled = true;

    f.action = "./indexBidProcess.php";
    return true;
}
</script>
<?}?>
<?
include_once("$g4[path]/tail.sub.php");
?>