Index: temp/trunk/html/forgot/index.php
===================================================================
--- temp/trunk/html/forgot/index.php	(revision 3634)
+++ temp/trunk/html/forgot/index.php	(revision 4608)
@@ -25,5 +25,5 @@
 	//¥á¥¢¥ÉÆþÎÏ»þ
 	$_POST['email'] = strtolower($_POST['email']);
-	$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND status = 2 AND delete = 0";
+	$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND status = 2 AND del_flg = 0";
 	$result = $conn->getAll($sql, array($_POST['email']) );
 	
@@ -36,5 +36,5 @@
 		$objPage->tpl_mainpage = 'forgot/secret.tpl';
 	} else {
-		$sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? AND status = 1 AND delete = 0";	//²¾ÅÐÏ¿Ãæ¤Î³Îǧ
+		$sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? AND status = 1 AND del_flg = 0";	//²¾ÅÐÏ¿Ãæ¤Î³Îǧ
 		$result = $conn->getAll($sql, array($_POST['email']) );
 		if ($result) {
@@ -51,5 +51,5 @@
 		// ¥Ò¥ß¥Ä¤ÎÅú¤¨¤Î²óÅú¤¬Àµ¤·¤¤¤«¥Á¥§¥Ã¥¯
 		
-		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND delete = 0";
+		$sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0";
 		$result = $conn->getAll($sql, array($_SESSION['forgot']['email']) );
 		$data = $result[0];