•  \n"; } else { // 희망대사 정보 가져오기 ======================================================= $sql = "SELECT * FROM `5th_hopeman` WHERE h_num = ".$i; $qry = dbQuery($sql); if(mysql_num_rows($qry)==0) { echo "
  • "; } else { while($rows = dbFetch2($qry)) { // 개별 희망씨앗수(후원자수) 구하기 $sql = "SELECT count(id) FROM new_support WHERE event_id = 5 AND state_service = 1 AND support_method = 'fix' and recommend_man = '".$rows[h_name]."'"; $qcount_3 = dbResult($sql); //정기후원 $sql = "SELECT count(id) FROM new_support WHERE event_id = 5 AND state_service = 1 AND support_method = 'once' and recommend_man = '".$rows[h_name]."' and ( respcode = '0000' or respcode = 'C000' )"; $qcount_4 = dbResult($sql); // 일시후원 $qcount2 = $qcount_3 + $qcount_4; // 희망제작소 센터장 모집후원회원수 플러스 if ($rows[h_name] == "송창석" ) // 송창석 { //$fix_hopeman = "주낙영, 이정희, 송유빈, 이승연, 이종오, 하왕수, 이우철, 박숙경, 오연경, 김학재"; $qcount2 = $qcount2 + 10; } else if ( $rows[h_name] == "문진수") // 문진수 { //$fix_hopeman = "강성봉, 고아라, 김동철, 노성철, 문병채, 정사랑, 최용묵, 한경화, 홍현주, 황순구"; $qcount2 = $qcount2 + 10; } else if ( $rows[h_name] == "한순웅") // 한순웅 { //$fix_hopeman = "이경민"; $qcount2 = $qcount2 + 1; } else if ( $rows[h_name] == "송중택") // 한순웅 { //$fix_hopeman = "이경민"; $qcount2 = $qcount2 + 10; } if ( $rows[h_num] == $i ) { echo "
  • \n"; echo "[".$rows[h_name]."] 희망씨앗 ".$qcount2."\n"; echo "
  • \n"; } } } } } } ?>
"; echo "document.getElementById('layer_detail').style.display = 'block';"; echo ""; } ?>