limit results

[Anon]

I have a site where the user can do a search and specify the number of results to display on each page. The array is the result of a multidimensional array_merge from three different mysql queries (that may sound strange but there's a very good reason for it) so I can't use mysql's LIMIT to limit the number of results I return.

I've got everything but how to return just the specified number of results. Once I get that part I can figure out how to do the incrementing to display results for the subsequent pages.

This is a simplified example of what I'm doing:

if($per_page == "")
$per_page = 20;
$list1 = query blah blah
$list2 = query blah blah
$list3 = query blah blah
$list = array_merge($list1, $list2, $list3);
$numrows = count($list);

do some sorting here..........

if($numrows > $per_page)
{

do some incrementing here if they ask for the next batch of results......

---------this is the bit i need----------

$return_list = the specified number of array results from $list (0-19 or 20-whatever);

---

}
else
{
$return_list = $list;
}

Then it get's passed to a template that loops through the results and displays them.

I hope that wasn't too vague. I know this has to be really simple but it's the simple things that always seem to trip me up 😉

Much thanks in advance.

[Anon]

Hi,

As per your code you are getting total no. of results to show. You can divide that no by no. of results you want to show on each page. That will return no. pages you are going to display. Now you will just have to place one for loop which will display results on particular page. Try out follwing

$numrows = count($list);

$page = $norows/(no. of results to be shown on page)

if(!isset($st))
{
$st = 0; // If it is first page
}

$et = $st + (no. of results to be shown on page)

for($k=$st;$k < $et; $k++)
{
// Display the results
}

Pass the appropiate starting counter($st)through privious/next links

I hope this will help you.

Regards,
Teena

[Anon]

Thanks for responding. What I'm actually trying to determine is if I can pass a chunk of the array to my template all at once instead of looping through them one at a time. Isn't there a way I can just make a new array that just contains $array[0] through $array[19]?

[Anon]

I wonder if I can use that same code to create the new array. If instead of doing this:

for($k=$st;$k < $et; $k++)
{
display results
}

it did this:

for($k=$st;$k < $et; $k++)
{
make new array
}

Would that work? Can I somehow use that to create a new array?

The only reason for wanting to do it that way is that I'm trying to keep as much of the php coding in the .inc to keep the template as clean as possible.

If that won't work I can just add the code to the template and do it that way.

Thanks again for taking the time to respond. It was extremely helpful.

[Anon]

You might want to have a look at array_slice().

http://www.php.net/array_slice

array array_slice (array array, int offset [, int length])

Array_slice() returns a sequence of elements from the array specified by the offset and length parameters.

[Anon]

Yes, that's exactly what I needed.

thanks a lot