摘要: 阅读全文
posted @ 2016-01-07 15:04 FinnYY 阅读(1231) 评论(0) 推荐(0) 编辑
摘要: public function rewardlog(){ $adminNav = C('ADMIN_NAV'); $adminNav[1]['class'] = 'cur'; $this->assign('adminNav',$adminNav); ... 阅读全文
posted @ 2016-01-07 14:49 FinnYY 阅读(636) 评论(0) 推荐(0) 编辑
摘要: 1、多表查询(左连接) SELECT a.*,b.*,b.id AS reid,c.*,c.id AS prid FROM `1008_user` a LEFT JOIN `1008_reward` b ON a.id = b.uid LEFT JOIN `1008_prize` c ON c.id 阅读全文
posted @ 2016-01-07 09:27 FinnYY 阅读(158) 评论(0) 推荐(0) 编辑