0) { $r = mysql_query("select T.* ,(select nm_brand from car_brand tsub where tsub.cd_brand = T.cd_brand) nm_brand ,(select nm_model from car_model tsub where tsub.cd_model = T.cd_model) nm_model ,(select nm_category from car_category tsub where tsub.cd_category = T.cd_category) nm_category from (SELECT mst.*, (select nm_model from car_model where cd_model = mst.cd_model ) as nm_model #, (select cd_category from car_model where cd_model = mst.cd_model ) as cd_category ,(select cd_brand from car_model sub where sub.cd_model = mst.cd_model ) cd_brand FROM car_model_sub mst $sql order by mst.cd_model desc LIMIT $pagestartpoint,$PageSize ) T "); $i=1; while($col = mysql_fetch_array($r)) { $tmpNum =$totalrows-($PageSize*($PageNo-1)); $no = ($tmpNum - $i)+1; ?>

번호	제조사	모델	세부모델	정보수정
				수정
등록된 정보가 없습니다.