car_option_view.php 935 B

1234567891011121314151617181920212223242526272829303132333435
  1. <?php
  2. include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
  3. // include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk.php';
  4. header("Content-Type: text/html; charset=utf-8");
  5. $cd_sale = $_GET['cd_sale'];
  6. if(empty($cd_sale)) {
  7. echo '해당 자료가 없습니다.';
  8. exit;
  9. }
  10. //차량 정보는 여기서 가져오도록 수정
  11. $sql ="SELECT
  12. a.*
  13. FROM sale_master s
  14. inner join car_master a on (s.cd_car = a.cd_car)
  15. left outer join car_model b on (a.cd_model = b.cd_model)
  16. left outer join car_grade c on (a.cd_grade = c.cd_grade)
  17. left outer join car_brand d on (a.cd_brand = d.cd_brand)
  18. left outer join car_model_sub e on (a.cd_model_sub = e.cd_model_sub)
  19. WHERE s.cd_sale='$cd_sale' ";
  20. $col=mysql_fetch_array(mysql_query($sql));
  21. $nm_cont_detail = $col['nm_cont_detail'];
  22. ?>
  23. <div class="options--list" >
  24. <?php include_once("../common/inc/inc_car_option.php")?>
  25. </div>
  26. <?
  27. exit;
  28. ?>