Pagination Help..

[FounderSim]

I am having trouble getting the pagination class to work in class_profile.php

I have the following code:

		$total = $mysidia->db->select(DUMMY_TEXT")->rowCount();
		
		if($total > 0)
		{
			
			
			$pagination = new Pagination($total, 10, "profile/view/{$mysidia->input->get("user")}");
			$pagination->setPage($mysidia->input->get("page"));	
///query loop result
$stmt = $mysidia->db->select("dummy_table", array("fieldID"), "DUMMY_QUERY ORDER BY fieldID LIMIT {$pagination->getLimit()},{$pagination->getRowsperPage()}");
$document->addLangvar($pagination->showPage());
                 }

It shows the text:

It navigates the to the page; url = www.dummyurl.com/profile/view/siminator/page-5

I can't fetch page #5 for some reason =0... Any ideas.