Split Page Results Implemetation

[philip937]

Ok peeps, going custom solution again!

Calling some entries from the database. Is it possible to use the standard split page results in order to have x number of outputted data on each page?

If so can someone that knows how give me some pointers how to implement from db query through to output method?

Thanks in advance.

:)

[kobra]

You can check coding for "productsAll" where there is an admin switch under config > maximum values > Maximum Display of Products All Page

This and many other pages have code to paginate after so many listings

[philip937]

You can check coding for "productsAll" where there is an admin switch under config > maximum values > Maximum Display of Products All Page

This and many other pages have code to paginate after so many listings

So it is possible then? split page results is a generic code that can be used for any database query?

[kobra]

split page results is a generic code that can be used for any database query?

Look at the code...."any DB query" is too broad . . . must be coded correctly

[philip937]

As in if I select from a table other than table products? I can use the same coding logic and it will work? That's what I mean by any db query.

[philip937]

So looking at this:

       if ($products_all_split->number_of_rows > 0) {
        $products_all = $db->Execute($products_all_split->sql_query);
        while (!$products_all->EOF) { 

So I need to inderstand what and where $products_all_split is?

[philip937]

Ah of course all set in the header file :-) think I should be ok to sort it now :-)