Forum Moderators: coopster
I have these 3 tables in my DB.
1. tbl.Member
a. name
b. email
c. username(pri key) ...and other stuff
2. tbl.Product
a. id (pri key)
b. product name
c. category .... and other stuff
d. company(from table maker)
3. tbl.Maker
a. id (pri key)
b. company
c. email and other stuff
When the members are browing products they choose and purchase most of the products(atleast they apply). These orders will be stored in the 4th table.
4. orders
a. id
b. product name
c. maker
d. username (from tbl.members)....and other stuff.
The question is when a member with username jaunty is browsing the products I want to show him an indication that he has already purchased item no 5,9,15 etc.
assuming that I use the following query on the browse product page..
$query = select * from products;
how should I modify $query so that I can also indicate that jaunty has purchased some of them.
I am very sure this should be a small trick I just want to make sure my DB structure and queries are proper.
Please help me
Thanks
