[eluser]LoganPHP[/eluser]
i got solution.........
Code:
$query = $this->db->query("Select job_title,date_format(job_date,'%d-%m-%Y') as job_date,job_description,contact FROM jobs_management LIMIT $offset, $limit");
Example with pagination:
Code:
function select_pagination($limit, $offset)
{
if($offset>1)
{
$offset=$offset;
}
else
{
$offset=0;
}
$query = $this->db->query("Select job_title,date_format(job_date,'%d-%m-%Y') as job_date,job_description,contact FROM jobs_management LIMIT $offset, $limit");
return $query->result();
}