June 21st, 2013, 02:35 AM
Adding products by retailer
hello guys, i have a login table where customer and retailer logins are stored. roles that are defined in the table are retailer and customer next to each login details.
customers and retailers both are given user_ids when registering. since i have many retailers who will add the same products but with different product details and prices, i want to know how to differentiate between those retailers when they add products. it will be much easier to do a query by retailer then.
every product added are stored in the tbl_product table in the database. queries are done from that table.
suppose retailer A has added product A, retailer B has added product A as well but with a different description and a different price.
is it possible? can i have a tutorial somewhere?
June 21st, 2013, 03:29 AM
in the products table add a retailer_id to associate each product with a retailer?
June 21st, 2013, 07:56 AM
Hance, this is your last warning. STOP CROSS POSTING
Click that link. In that link, I answered your question 4 days ago.
Last warning. If you make a duplicate thread again you're banned.
HEY! YOU! Read the New User Guide and Forum Rules
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin
"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002
Think we're being rude? Maybe you asked a bad question
or you're a Help Vampire.
Trying to argue intelligently? Please read this.