Sandbox

Posted: **Fri Feb 22, 2008 9:21 pm**

Hi,

Using the MVC methodology, how do you get the pagination to work?

I want to use JPagination as per:

		jimport('joomla.html.pagination');
		$pageNav = new JPagination( $total, $limitstart, $limit );

And the query in the fashion:

Code: Select all

$db->setQuery( $query, $pageNav->limitstart, $pageNav->limit );

But if the model code is:

Code: Select all

	function _buildQuery()
	{
		$query = ' SELECT * FROM #__gphmgrgraphs ORDER BY graphID ASC, graphRowID ASC';

		return $query;
	}
	
	function getData()
	{
		// Lets load the data if it doesn't already exist
		if (empty( $this->_data ))
		{
			$query = $this->_buildQuery();
			$this->_data = $this->_getList( $query );
		}

		return $this->_data;
	}

I can't see how I can get this to work.

Any ideas?

Thanks,

StuG

Posted: **Sat Feb 23, 2008 1:13 am**

Stu,

This Jpagination page in the Documentation Wiki that I've been working on should help.

Posted: **Sat Feb 23, 2008 9:13 am**

Bargain!

TVM,

StuG

Sandbox

[SOLVED] Pagination in J!1.5

[SOLVED] Pagination in J!1.5

Re: Pagination in J!1.5

Re: Pagination in J!1.5