[eluser]SaSa[/eluser]
I have an problem with
rownum in following code. it is this that, in
each page of pagination rows in table
be counted from the beginning. For
example, the clear:
P1: If we're on the
first page of pagination, rows are the counts:
Code:
1 Columns1
2 Columns2
3 Columns3
4 Columns4
P2: If we're on the
second page of pagination, rows are the counts:
Code:
1 Columns5
2 Columns6
3 Columns7
4 Columns8
<br>
P2: The I want to be counted row in table,(on the
second page of pagination and ...):
Code:
5 Columns5
6 Columns6
7 Columns7
8 Columns8
P3: ... and more
This code:
Code:
$data['results'] = $this->db->query("SELECT @rownum:=@rownum+1 rownum, t.* ".
"FROM (SELECT @rownum:=0) r, hotel_submits t ".
"ORDER BY id desc LIMIT $offset, 4");
Full code:
Code:
function show($offset = 0)
{
$this->load->library('pagination');
$config['base_url'] = base_url().'admin/accommodation/show';
$config['uri_segment'] = 4;
$config['total_rows'] = $this->db->count_all('hotel_submits');
$config['per_page'] = '4';
$this->pagination->initialize($config);
$data['pagination'] = $this->pagination->create_links();
$offset = (int) $offset; // just to make sure nothing funky gets in here
$data['results'] = $this->db->query("SELECT @rownum:=@rownum+1 rownum, t.* ".
"FROM (SELECT @rownum:=0) r, hotel_submits t ".
"ORDER BY id desc LIMIT $offset, 4");
////////////////////////
$this->load->view('admin/accommodation_submit_show', $data);
}
How is it?
With respect