Clarification.
I'm using modular arithmetic on a table of recently viewed items. My fields
are:
user_id, pid0, pid1, pid2, pid3, pid4, inc
user_id is the user's unique identification.
pid* is the product's unique identification.
inc is a number, modulo 5, corresponding to
the last pid col
Let key represent the field name.
Let value reference the data at the 'current' key.
Suppose we have a sample table:
++--+--+--+++
| id | key0 | key1 | key2 | other1 | other2 |
++--+--+--+++
| 0 | data | none | none | data | none