번호	아이디	이름	연락처	등록일

= numbers . n-1 where cd_dealer = $cd_dealer_p ) "; $sql1 = " and cd_dealer_p = '$cd_dealer_p' "; $sql = $sql. " and s.ds_status in ('E0','F0')"; $sql = $sql. " and s.cd_sale not in (select cd_sale from tender_master where ds_delind = 'N' and cd_dealer_p = '$cd_dealer_p' group by cd_sale)"; $r = mysql_query("SELECT a.* , b.nm_model , d.nm_brand , 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.ds_status ds_status_sale , case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_sale , case when a.nm_act_yn in ('Y') then '유' else '무' end as nm_act_yn_name 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_brand d on (a.cd_brand = d.cd_brand) $sql $orderby LIMIT $pagestartpoint,$PageSize"); $i=1; while($col = mysql_fetch_array($r)) { ?>

번호	판매자	지역	차종	주행거리	년식	등록일	입찰 마감시간
				km

번호	판매자	지역	차종	주행거리	년식	등록일	상태
				km