Page 1 of 1

recordset from field content?

Posted: 2014-07-11 17:07
by antonio
Hi all,
I have a Product table and a Pages table.
In the Product page I have all usual fields (ID, name, description...) AND a specific field (pages) that should contains all page numbers (related to a paper catalogue) separate by comma (example: 123, 124, 125).

Then in the front-end I should create a recordset that allow me to show the product page by page.
Example:
the first page of the product should show:

[page123.jpg]
[next]

If you click next, then, you'll see this:

[page124.jpg]
[prevoius] - [next]

And so on.

This is easy to do with a regular recordset consisting in 3 records and pagination tools. But how can I do this using only one field containing these 3 pages?

Any idea will be really appreciated.

Thank you in advance.

tony

Re: recordset from field content?

Posted: 2014-07-23 18:43
by Fred
I suppose you have two options here.
If it is not a long list you could use some carousell to page between them.

The other way would be to use an array and add the content of the field into a multidimensional array and then paginate that instead of a recordset.