|
很好很强大,但是我自己照着写了个,写了好久都没分出页来!
打开数据表是以下代码:高手帮忙看下!
$user_id = "27";
$select = $this->db->select();
$select->from('user_4scar AS a','*')
->join('tb_cartype_list AS b','a.BAS_CARTYPELIST_ID = b.F_id','F_jutitype')
->join('tb_cartype_allcar AS c','b.F_allcar_id = c.F_id','F_character')
->join('tb_group_carchara AS d','c.F_carchara_id = d.F_id','f_classname')
->where('a.BAS_USER_ID = ?',$user_id)
->where('a.BAS_IFDEL = ?','F')
->order('BAS_DATE desc');
$sql = $select->__toString();
$row = $this->db->fetchAll($sql);
$this->views->assign('date',$row);
$this->views->display("userproduct/carlist.htm");
unset($select,$sql,$result);
|