Index: temp/trunk/html/admin/contents/recommend.php
===================================================================
--- temp/trunk/html/admin/contents/recommend.php	(revision 8388)
+++ temp/trunk/html/admin/contents/recommend.php	(revision 8390)
@@ -19,5 +19,4 @@
 
 $conn = new SC_DBConn();
-$objQuery = new SC_Query();
 $objPage = new LC_Page();
 $objView = new SC_AdminView();
@@ -48,6 +47,6 @@
 	if ( ! $objPage->arrErr[$objPage->arrForm['rank']]) {
 		// ¸Å¤¤¤Î¤ò¾Ã¤¹
-		$sql = "DELETE FROM dtb_best_products WHERE product_id = ?";
-		$conn->query($sql, array($objPage->arrForm['product_id']));
+		$sql = "DELETE FROM dtb_best_products WHERE category_id = ? AND rank = ?";
+		$conn->query($sql, array($objPage->arrForm['category_id'] ,$objPage->arrForm['rank']));
 	
 		// £Ä£ÂÅÐÏ¿
@@ -56,5 +55,7 @@
 		$objPage->arrForm['create_date'] = "NOW()";
 		
+		$objQuery = new SC_Query();
 		$objQuery->insert("dtb_best_products", $objPage->arrForm );
+//		$conn->autoExecute("dtb_best_products", $objPage->arrForm );
 	}	
 
@@ -62,7 +63,22 @@
 // ºï½ü»þ
 
-	$sql = "DELETE FROM dtb_best_products WHERE product_id = ?";
-	$conn->query($sql, array($_POST['product_id']));
+	$sql = "DELETE FROM dtb_best_products WHERE category_id = ? AND rank = ?";
+	$conn->query($sql, array($_POST['category_id'] ,$_POST['rank']));
 	
+}
+
+// ¥«¥Æ¥´¥êID¼èÆÀ ̵¤¤¤È¤­¤Ï¥È¥Ã¥×¥Ú¡¼¥¸
+if ( sfCheckNumLength($_POST['category_id']) ){
+	$objPage->category_id = $_POST['category_id'];
+} else {
+	$objPage->category_id = 0;
+}
+
+// ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë
+$sql = "SELECT B.name, B.main_list_image, A.* FROM dtb_best_products as A INNER JOIN dtb_products as B USING (product_id)
+		 WHERE A.del_flg = 0 ORDER BY rank";
+$arrItems = $conn->getAll($sql, array($objPage->category_id));
+foreach( $arrItems as $data ){
+	$objPage->arrItems[$data['rank']] = $data;
 }
 
@@ -81,11 +97,11 @@
 }
 
-// ¥ª¥¹¥¹¥á¾¦ÉʼèÆÀ
-lfGetRecommentdProduct();
-
 //³Æ¥Ú¡¼¥¸¶¦ÄÌ
 $objPage->cnt_question = 6;
 $objPage->arrActive = $arrActive;
 $objPage->arrQuestion = $arrQuestion;
+
+// ¥«¥Æ¥´¥ê¼èÆÀ
+$objPage->arrCatList = sfGetCategoryList("level = 1");
 
 //----¡¡¥Ú¡¼¥¸É½¼¨
@@ -124,17 +140,3 @@
 }
 
-/* ¾¦ÉʤΰìÍ÷¤ò¼èÆÀ */
-function lfGetRecommentdProduct() {
-	
-	global $objQuery;
-	global $objPage;
-	
-	// ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë
-	$sql = "SELECT B.name, B.main_list_image, A.* FROM dtb_best_products as A INNER JOIN dtb_products as B USING (product_id)
-			 WHERE A.del_flg = 0 ORDER BY rank";
-	$arrItems = $objQuery->getAll($sql);
-	foreach( $arrItems as $data ){
-		$objPage->arrItems[$data['rank']] = $data;
-	}
-}
 ?>