How would one go about creating a watchlist?
I have two tables, one with products and a foreign key for the customer. The other is a watchlist with the product id and the fk for the customer.

How would I go about looping the product information from the products table where the fk matches the session id in the watchlist?

My mind is blank and google isn't helping!

Many thanks.
How would one go about creating a watchlist?
===

I have two tables, one with products and a foreign key for the customer. The other is a watchlist with the product id and the fk for the customer.

How would I go about looping the product information from the products table where the fk matches the session id in the watchlist?

My mind is blank and google isn't helping!

Many thanks.