include("../inc/inc_top.php") ?>
include("../inc/inc_header.php") ?>
입찰중 리스트
if($totalrows>0) {
$r = mysql_query("SELECT
a.*
, b.nm_model
, c.nm_grade
, d.nm_brand
, e.nm_model_sub
, getCode('car_master','ds_type',a.ds_type) as nm_type
, getCode('car_master','ds_open',a.ds_open) as nm_open
, getCode('car_master','ds_sales',a.ds_sales) as nm_sales
, getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
, getCode('member_master','ds_area',s.ds_area) as nm_area
, getCode('sale_master','ds_status',s.ds_status) as nm_status
, s.cd_sale
, s.nm_name nm_name_sale
, s.nm_recommend nm_recommend_sale
, s.ds_status ds_status_sale
, s.ds_status_contract ds_status_contract_sale
, getRemainTimeByPhase(".LIMIT_TIME_TENDER.", ".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell
FROM sale_master s
inner join car_master a
on (s.cd_car = a.cd_car)
left outer join car_model b
on (a.cd_model = b.cd_model)
left outer join car_grade c
on (a.cd_grade = c.cd_grade)
left outer join car_brand d
on (a.cd_brand = d.cd_brand)
left outer join car_model_sub e
on (a.cd_model_sub = e.cd_model_sub)
$sql $orderby LIMIT $pagestartpoint,$PageSize");
$i=1;
while($col = mysql_fetch_array($r)) {
$tmpNum =$totalrows-($PageSize*($PageNo-1));
$no = ($tmpNum - $i)+1;
?>
번호
판매자
차종
차량번호
주행거리
색상
변속기
지역
판매시간
등록일
재입찰
재입찰
$i++;
}
}else{
?>
=$no?>
=$col[nm_name_sale]?>
=$col[nm_brand]." ".$col[nm_model]?>
=$col[nm_number]?>
=$col[nm_mileage]?>km
=$col[nm_color]?>
=$col[nm_transmission]?>
=$col[nm_area]?>
=$col[time_limit_sell]?>
=$col[dt_insert]?>
입찰시간 초기화
입찰시간 및 내역 초기화
}
?>
등록된 정보가 없습니다.