Page pagination from an array

Hello All

I have a 2 question.

i have my relational database set up and its running a treat.

Now when i call my sql i dump the results into an array so i can reuse that data on the same page.

I then use that array to display the pulled data onto that page.

  1. How can i limit that pulled data to show one or how ever many i want?

  2. I’ve looked at a few pagination codes and the all ask for the to use the sql i was wondering if it was possible to use this array instead to use a pagination on?

ok 3. If so any advice?