Index: branches/dev/html/admin/mail/index.php
===================================================================
--- branches/dev/html/admin/mail/index.php	(revision 11744)
+++ branches/dev/html/admin/mail/index.php	(revision 11749)
@@ -141,5 +141,4 @@
 		//-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ	
 		$objSelect = new SC_CustomerList($objPage->list_data, "magazine");
-
 		// À¸À®¤µ¤ì¤¿WHEREʸ¤ò¼èÆÀ¤¹¤ë		
 		list($where, $arrval) = $objSelect->getWhere();
@@ -165,19 +164,21 @@
 		// ɽ¼¨½ç½ø
 		$objQuery->setorder("customer_id DESC");
+		
 		// ¸¡º÷·ë²Ì¤Î¼èÆÀ
-		$col = "dtb_customer.customer_id,
-			dtb_customer.name01,
-			dtb_customer.name02,
-			dtb_customer.kana01,
-			dtb_customer.kana02,
-			dtb_customer.sex,
-			dtb_customer.email,
-			dtb_customer.tel01,
-			dtb_customer.tel02,
-			dtb_customer.tel03,
-			dtb_customer.pref,
-			dtb_customer.mailmaga_flg";
+		$is_mobile = false;
+		switch($_POST['mail_type']) {
+			case 1:
+				$is_mobile = false;
+				break;
+			case 2:
+				$is_mobile = true;		
+				break;
+			default:
+				$is_mobile = false;
+				break;
+		}
+		$col = $objSelect->getListMailMagazine($is_mobile);
 		$objPage->arrResults = $objQuery->select($col, $from, $where, $arrval);
-
+sfprintr($where);
 		//¸½ºß»þ¹ï¤Î¼èÆÀ
 		$objPage->arrNowDate = lfGetNowDate();
@@ -397,6 +398,6 @@
 	
 	$objQuery = new SC_Query();
-		
 	$objSelect = new SC_CustomerList( lfConvertParam($arrData, $arrSearchColumn), "magazine" );
+	
 	$search_data = $conn->getAll($objSelect->getListMailMagazine(), $objSelect->arrVal);
 	$dataCnt = count($search_data);