So say I have a database called "orders" with a couple of columns:

name, email, ccinfo, product1key, product2key, product3key, etc.

Each row is a separate order. Product1key, 2, and 3 are license keys.

Let's say John Doe first buys product1, then buys product2 in a separate transaction. He uses the same email address for both of these.

I want to write a function that will retrieve every single license key that email address has ever bought. Right now it only currently retrieves the first one, and so would only retrieve product1 in John's case. How would I make it so it retrieves every key he's bought, even if he got them on separate orders?

Thanks much.

try grouping each product key to the same table, call it something like "Product Keys"

and give each distinct key (Product1key, 2, 3) it's own row in said table.

SELECT product1key,product2key,product3key FROM orders WHERE name = 'value_for_name';

Ah, very nice. Thank you!