批量增加浏览量(适用于新站)
方式1、(为当前模块的所有信息增加)
update destoon_company set hits=hits+100; update destoon_sell_5 set hits=hits+100; update destoon_buy_6 set hits=hits+100; update destoon_article_21 set hits=hits+100;
方式2、(只为浏览次数小于800的信息增加)
update destoon_company set hits=hits+100 where hits<800; update destoon_sell_5 set hits=hits+100 where hits<800; update destoon_buy_6 set hits=hits+100 where hits<800; update destoon_article_21 set hits=hits+100 where hits<800;
方式3、(只为单个会员或者单条信息增加),注意公司有两种方式,一种是获取会员id,一种是获取会员用户名
update destoon_company set hits=hits+100 where userid=2847; update destoon_company set hits=hits+100 where username='xiaohei'; update destoon_sell_5 set hits=hits+100 where itemid=418; update destoon_buy_6 set hits=hits+100 where itemid=418; update destoon_article_21 set hits=hits+100 where itemid=418;