Changeset 5258


Ignore:
Timestamp:
2006/09/20 14:40:17 (20 years ago)
Author:
kakinaka
Message:

blank

Location:
temp/trunk
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • temp/trunk/data/lib/slib.php

    r5204 r5258  
    17511751    // ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë 
    17521752    $sql = "SELECT name, main_image, main_list_image, price01_min, price01_max, price02_min, price02_max, point_rate, 
    1753              A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass as B  
     1753             A.product_id, A.comment FROM dtb_best_products as A LEFT JOIN vw_products_allclass AS allcls  
    17541754            USING (product_id) WHERE A.category_id = ? AND A.del_flg = 0 AND status = 1 ORDER BY A.rank"; 
    17551755    $arrItems = $conn->getAll($sql, array($category_id)); 

  • temp/trunk/html/admin/mail/inc_mailmagazine.php

    r4608 r5258  
    8383 
    8484    // ¥á¥¤¥ó¾¦ÉʤξðÊó¼èÆÀ 
    85     $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?"; 
     85    $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?"; 
    8686    $main = $conn->getAll($sql, array($list_data["main_product_id"])); 
    8787    $list_data["main"] = $main[0]; 
    8888 
    8989    // ¥µ¥Ö¾¦ÉʤξðÊó¼èÆÀ 
    90     $sql = "SELECT product_id, name, main_list_image, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?"; 
     90    $sql = "SELECT product_id, name, main_list_image, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?"; 
    9191    $k = 0; 
    9292    $l = 0; 

  • temp/trunk/html/admin/mail/preview.php

    r1328 r5258  
    4242     
    4343    // ¥á¥¤¥ó¾¦ÉʤξðÊó¼èÆÀ 
    44     $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass WHERE product_id = ?"; 
     44    $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?"; 
    4545    $main = $conn->getAll($sql, array($objPage->list_data["main_product_id"])); 
    4646    $objPage->list_data["main"] = $main[0]; 

  • temp/trunk/html/admin/products/product.php

    r5253 r5258  
    167167 
    168168        if($_POST[$keyname] != "" && $_POST[$delkey] != 1) { 
    169             $arrRet = $objQuery->select("main_list_image, product_code_min, name", "vw_products_allclass", "product_id = ?", array($_POST[$keyname]));  
     169            $arrRet = $objQuery->select("main_list_image, product_code_min, name", "vw_products_allclass AS allcls", "product_id = ?", array($_POST[$keyname]));  
    170170            $arrRecommend[$i] = $arrRet[0]; 
    171171            $arrRecommend[$i]['product_id'] = $_POST[$keyname]; 

  • temp/trunk/html/frontparts/bloc/best5.php

    r5257 r5258  
    2929    $where = "status = 1"; 
    3030    $order = "rank"; 
    31     $objQuery->setorder($order); 
    3231     
    3332    $arrBestProducts = $objQuery->select($col, $from, $where); 
Note: See TracChangeset for help on using the changeset viewer.