- Timestamp:
- 2006/10/24 13:08:12 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/html/rss/product.php (modified) (4 diffs)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/rss/product.php
r6478 r6479 22 22 $objSiteInfo = new SC_SiteInfo(); 23 23 24 sfprintr($objSiteInfo);25 exit();26 27 24 //¿·Ãå¾ðÊó¤ò¼èÆÀ 28 25 $arrProduct = lfGetProductsDetail($objQuery, 1); … … 35 32 36 33 //¾¦ÉʾðÊó¤ò¥»¥Ã¥È 37 $objPage-> $arrProduct = $arrProduct;34 $objPage->arrProduct = $arrProduct; 38 35 39 36 //Ź̾¤ò¥»¥Ã¥È … … 56 53 * °ú¿ô£²:$product_id ¾¦ÉÊID 57 54 * Ìá¤êÃÍ:$arrProduct ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹ 58 ************************************************************************************************************** */55 **************************************************************************************************************/ 59 56 function lfGetProductsDetail($objQuery, $product_id){ 60 57 $sql = ""; … … 83 80 } 84 81 85 /***************************************************************************************************************86 * ´Ø¿ô̾:lfGetNews87 * ÀâÌÀ¡¡:¿·Ãå¾ðÊó¤ò¼èÆÀ¤¹¤ë88 * °ú¿ô£±:$objQuery DBÁàºî¥¯¥é¥¹89 * Ìá¤êÃÍ:$arrNews ¼èÆÀ·ë²Ì¤òÇÛÎó¤ÇÊÖ¤¹90 ***************************************************************************************************************/91 function lfGetShopData($objQuery){92 $col = "";93 $col .= " news_id "; //¿·Ãå¾ðÊóID94 $col .= " ,news_title "; //¿·Ãå¾ðÊ󥿥¤¥È¥ë95 $col .= " ,news_comment "; //¿·Ãå¾ðÊóËÜʸ96 $col .= " ,to_char(news_date, 'YYYY') AS YEAR "; //ÆüÉÕ(ǯ)97 $col .= " ,to_char(news_date, 'MM') AS MONTH "; //ÆüÉÕ(·î)98 $col .= " ,to_char(news_date, 'DD') AS DAY "; //ÆüÉÕ(Æü)99 $col .= " ,to_char(news_date, 'HH24') AS HOUR "; //ÆüÉÕ(»þ´Ö)100 $col .= " ,to_char(news_date, 'MI') AS MINUTE "; //ÆüÉÕ(ʬ)101 $col .= " ,to_char(news_date, 'SS') AS SECOND "; //ÆüÉÕ(ÉÃ)102 $col .= " ,news_url "; //¿·Ãå¾ðÊóURL103 $col .= " ,news_select "; //¿·Ãå¾ðÊó¤Î¶èʬ(1:URL¡¢2:ËÜʸ)104 $col .= " ,(SELECT shop_name FROM dtb_baseinfo limit 1) AS shop_name "; //Ź̾105 $col .= " ,(SELECT email04 FROM dtb_baseinfo limit 1) AS email "; //ÂåɽEmail¥¢¥É¥ì¥¹106 $from = "dtb_news";107 $where = "del_flg = '0'";108 $order = "rank DESC";109 $objQuery->setorder($order);110 $arrNews = $objQuery->select($col,$from,$where);111 return $arrNews;112 }113 114 115 82 ?>
Note: See TracChangeset
for help on using the changeset viewer.
