$sub_sql = "select dt_insert from tender_master tm where tm.cd_dealer_p = '".$col['cd_dealer']."' order by cd_tender desc limit 1"; $sub_r = mysql_query($sub_sql); $sub_col = mysql_fetch_array($sub_r); $d1_sql = "select cd_dealer, cd_dealerid, nm_company, nm_name, concat(nm_hp_01, concat(nm_hp_02,nm_hp_03)) as nm_hp, ds_status, dt_insert, dt_lastlogin from dealer_master dm where ds_delind='N' and ds_type = 'D1' and cd_dealer_p = '".$col['cd_dealer']."'"; $d1_res = mysql_query($d1_sql); $d1_cnt = mysql_num_rows($d1_res); ?>
| No | =iconv("UTF-8", "EUC-KR", "상호");?> | =iconv("UTF-8", "EUC-KR", "관리자이름 및 아이디");?> | =iconv("UTF-8", "EUC-KR", "연락처");?> | for($i=0; $i < 5; $i++) {?>=iconv("UTF-8", "EUC-KR", "관리자이름 및 아이디");?> | =iconv("UTF-8", "EUC-KR", "연락처");?> | } ?>=iconv("UTF-8", "EUC-KR", "최종입찰일");?> | =iconv("UTF-8", "EUC-KR", "최종로그인");?> | ||
| =$cnt?> | =iconv("UTF-8", "EUC-KR", $col[nm_company]);?> | =iconv("UTF-8", "EUC-KR", $col[nm_name]);?> =iconv("UTF-8", "EUC-KR", $col[cd_dealerid]);?> | ' =iconv("UTF-8", "EUC-KR", $col[nm_hp]);?> | while($d1_row = mysql_fetch_array($d1_res)) { ?>=iconv("UTF-8", "EUC-KR", $d1_row[nm_name]);?> =iconv("UTF-8", "EUC-KR", $d1_row[cd_dealerid]);?> | ' =iconv("UTF-8", "EUC-KR", $d1_row[nm_hp]);?> | } ?> for($i=$d1_cnt;$i < 5;$i++) { ?>} ?> | =iconv("UTF-8", "EUC-KR", $sub_col[dt_insert]);?> | =iconv("UTF-8", "EUC-KR", $col[dt_lastlogin]);?> |