Index: temp/trunk/data/class/SC_DbConn.php
===================================================================
--- temp/trunk/data/class/SC_DbConn.php	(revision 4709)
+++ temp/trunk/data/class/SC_DbConn.php	(revision 4712)
@@ -51,5 +51,5 @@
 	function getOne($n, $arr = ""){
 		
-		sfprintr($n);
+//		sfprintr($n);
 		
 		// mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë
Index: temp/trunk/data/conf/conf.php
===================================================================
--- temp/trunk/data/conf/conf.php	(revision 4709)
+++ temp/trunk/data/conf/conf.php	(revision 4712)
@@ -757,15 +757,15 @@
 $arrView = array(
 	"vw_cross_class" => '
-		SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
-		FROM dtb_classcategory AS T1, dtb_classcategory AS T2;
+		(SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
+		FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) vw_cross_class ',
 		
-		CREATE VIEW vw_cross_products_class AS
-		SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id,
+	"vw_cross_products_class" =>'
+		(SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id,
 		T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2
 		FROM vw_cross_class AS T1 LEFT JOIN dtb_products_class AS T2 
-		ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2;
+		ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) vw_cross_products_class ',
 		
-		CREATE VIEW vw_products_nonclass AS 
-		SELECT * FROM dtb_products AS T1 LEFT JOIN 
+	"vw_products_nonclass" => '
+		(SELECT * FROM dtb_products AS T1 LEFT JOIN 
 		(SELECT
 		product_id AS product_id_sub,
@@ -779,8 +779,8 @@
 		FROM dtb_products_class WHERE classcategory_id1 = 0 AND classcategory_id2 = 0) 
 		AS T2
-		ON T1.product_id = T2.product_id_sub',
-		
+		ON T1.product_id = T2.product_id_sub) vw_products_nonclass ',
+	
 	"vw_products_allclass" => '
-		SELECT product_id,product_code_min,product_code_max,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
+		(SELECT product_id,product_code_min,product_code_max,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
 		category_rank,category_id,del_flg,status,name,comment1,comment2,comment3,rank,
 		main_list_comment,main_image,main_list_image,product_flag,deliv_date_id,sale_limit,point_rate,sale_unlimited,create_date,deliv_fee
@@ -800,8 +800,8 @@
 		FROM dtb_products_class GROUP BY product_id) AS T2
 		ON T1.product_id = T2.product_id_sub) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4
-		ON T3.category_id = T4.sub_category_id',
+		ON T3.category_id = T4.sub_category_id) vw_products_allclass ',
 
 	"vw_products_allclass_detail" => '
-		SELECT product_id,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
+		(SELECT product_id,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
 		del_flg,status,name,comment1,comment2,comment3,deliv_fee,main_comment,main_image,main_large_image,
 		sub_title1,sub_comment1,sub_image1,sub_large_image1,
@@ -824,8 +824,8 @@
 		FROM dtb_products_class GROUP BY product_id) AS T2
 		ON T1.product_id = T2.product_id_sub) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4
-		ON T3.category_id = T4.sub_category_id',
+		ON T3.category_id = T4.sub_category_id) vw_products_allclass_detail ',
 
 	"vw_product_class" => '
-		SELECT * FROM 
+		(SELECT * FROM 
 		(SELECT T3.product_class_id, T3.product_id AS product_id_sub, classcategory_id1, classcategory_id2, 
 		T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2,
@@ -835,10 +835,10 @@
 		AS T3 LEFT JOIN dtb_classcategory AS T4
 		ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6
-		ON product_id_sub = T6.product_id',
+		ON product_id_sub = T6.product_id) vw_product_class ',
 
 	"vw_category_count" => '
-		SELECT T1.category_id, T1.category_name, T1.parent_category_id, T1.level, T1.rank, T2.product_count
+		(SELECT T1.category_id, T1.category_name, T1.parent_category_id, T1.level, T1.rank, T2.product_count
 		FROM dtb_category AS T1 LEFT JOIN dtb_category_total_count AS T2
-		ON T1.category_id = T2.category_id'
+		ON T1.category_id = T2.category_id) vw_category_count '
 );
 
Index: temp/trunk/data/lib/slib.php
===================================================================
--- temp/trunk/data/lib/slib.php	(revision 4709)
+++ temp/trunk/data/lib/slib.php	(revision 4712)
@@ -2340,5 +2340,8 @@
 }
 
-function sfGetFrom(){
+function sfChangeView($sql){
+	global $arrView;
+	
+	sfprintr($arrView);
 	
 }
Index: temp/trunk/html/test/kakinaka/mysql.php
===================================================================
--- temp/trunk/html/test/kakinaka/mysql.php	(revision 4711)
+++ temp/trunk/html/test/kakinaka/mysql.php	(revision 4712)
@@ -17,16 +17,3 @@
 */
 
-$sql = "SELECT * FROMdtb_baseinfoWHERE";
-$sql = getMailAddress($sql);
-print_r($sql);
-
-print("end");
-
-// ʸ»úÎó¤ÎÃæ¤Ë¸ºß¤¹¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤Î¤ß¤ò¼èÆÀ¤·¡¢ÇÛÎó¤È¤·¤ÆÊÖ¤¹
-function getMailAddress($str){
-	$arrMail = array();
-	preg_match_all("/FROM+([a-zA-Z0-9_\.\+\?-]+WHERE)/", $str, $arrMail);
-	return $arrMail[0];
-}
-
 ?> 
Index: temp/trunk/html/admin/home.php
===================================================================
--- temp/trunk/html/admin/home.php	(revision 4670)
+++ temp/trunk/html/admin/home.php	(revision 4712)
@@ -17,4 +17,6 @@
 // ǧ¾Ú²ÄÈݤÎȽÄê
 sfIsSuccess($objSess);
+
+sfprintr(sfChangeView("ss"));
 
 // ¸½ºß¤Î²ñ°÷¿ô