Pagination [doing my head in]...anyone...please?

[eluser]bretticus[/eluser]
Want to provide...oh maybe...an error message or two?

By the way, what is the purpose of...

Code:

if($property_type == 0)
   {
      $sql = "SELECT * FROM properties ";
   }

...because, unless that if statement is true, you have an incomplete query as it is followed by...

Code:

// more queries here
   $sql .= " LIMIT ".$limit.", ".$offset.";";
   $query = $this->db->query($sql);

...and that may be the source of "its screwing up!" So, again, please provide your error message(s).

Cheers!