#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    30
    Rep Power
    0

    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?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Dec 2004
    Posts
    2,868
    Rep Power
    368
    in the products table add a retailer_id to associate each product with a retailer?
  4. #3
  5. Sarcky
    Devshed Supreme Being (6500+ posts)

    Join Date
    Oct 2006
    Location
    Pennsylvania, USA
    Posts
    10,692
    Rep Power
    6351
    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.

IMN logo majestic logo threadwatch logo seochat tools logo