Re: How to select field names?

2004-09-07 Thread Jeremy McEntire
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

How to select field names?

2004-09-07 Thread Jeremy McEntire
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