Page display

[howster_78]

I am creating a webpage where I collect data from several queries.
There shall only be 25 presentations on each page. As the array is built up from six different queries I have found it hard to present the data as requested.

Does anyone have a nice script for displaying this page, and only 25 on each page?
Sorry for the awkward explanation.

[bogu]

Did u try the search on the forum about "paging"?

[howster_78]

I have looked through it, but still has not found a satisfying answer. The problem is that people use "limit", and I have done that earlier too. But as I fetch result into an array from six different queries the "limit" will not help me.

So hopefully someone has done this before and can give me a little tip.

Thanks

[bogu]

Ofcource u can limit, but u need to limit your array, just play with arrays.
After u create your array, u can manipulated this way ...

//your array
$arr = array(
	0 => '1',
	1 => '2',
	2 => '3',
	....
	n => 'n+1'
);

//array for paging
$arr = array(   

	0 => array (
		0 => '1',
		1 => '2',
		...
		20 => '21'
	)
	1 => array (
		21 => '22',
		22 => '23',
		...
		40 => '41'
	)
	....
	m => array (
		n-20 => 'n-19',
		n-19 => 'n-18',
		...
		n => 'n+1'
	)
)

now u have split your array into "m" pages.

Have fun coding ... 😃

[Weedpacket]

You should be able to write the six different queries as one (using a UNION clause), assuming that the results are all the same format.