Changeset 17701
- Timestamp:
- 2008/11/09 14:52:49 (18 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_Inquiry.php
r17144 r17701 57 57 '質問ID', 58 58 '回答日時', 59 ' 回答名',59 'アンケートタイトル', 60 60 '顧客名1', 61 61 '顧客名2', … … 169 169 $objCSV = new SC_Helper_CSV_Ex(); 170 170 $head = SC_Utils_Ex::sfGetCSVList($this->arrCVSTITLE); 171 $list_data = $conn->getAll("SELECT result_id,question_id,question_date,question_name,name01,name02,kana01,kana02,zip01,zip02,pref,addr01,addr02,tel01,tel02,tel03,mail01,question01,question02,question03,question04,question05,question06 FROM dtb_question_result WHERE del_flg = 0 AND question_id = ? ORDER BY result_id ASC",array($_GET['question_id'])); 171 $sql =<<<__EOS__ 172 SELECT 173 dtb_question_result.result_id 174 ,dtb_question_result.question_id 175 ,dtb_question_result.create_date 176 ,dtb_question.question_name 177 ,dtb_question_result.name01 178 ,dtb_question_result.name02 179 ,dtb_question_result.kana01 180 ,dtb_question_result.kana02 181 ,dtb_question_result.zip01 182 ,dtb_question_result.zip02 183 ,dtb_question_result.pref 184 ,dtb_question_result.addr01 185 ,dtb_question_result.addr02 186 ,dtb_question_result.tel01 187 ,dtb_question_result.tel02 188 ,dtb_question_result.tel03 189 ,dtb_question_result.mail01 190 ,dtb_question_result.question01 191 ,dtb_question_result.question02 192 ,dtb_question_result.question03 193 ,dtb_question_result.question04 194 ,dtb_question_result.question05 195 ,dtb_question_result.question06 196 FROM dtb_question_result 197 LEFT JOIN dtb_question 198 ON dtb_question_result.question_id = dtb_question.question_id 199 WHERE 0=0 200 AND dtb_question_result.del_flg = 0 201 AND dtb_question_result.question_id = ? 202 ORDER BY dtb_question_result.result_id ASC 203 __EOS__; 204 $list_data = $conn->getAll($sql, array($_GET['question_id'])); 172 205 $data = ""; 173 206 for($i = 0; $i < count($list_data); $i++) {
Note: See TracChangeset
for help on using the changeset viewer.
