Jump to content

MySQL Duplicate Data Problem


Recommended Posts

Well I'm coding a website with MySQL functionality. The page I'm working on is a page where one person can look up information on another person that they sponsor. There is a checklist that each sponsor much complete for each affiliate, and the values of these checkboxes must be saved to the MySQL database for retrieval later.Keep in mind each sponsor can have multiple affiliates and each of them need their own checkbox data for the sponsor.For example here is some randomly made up dataSponsor ID Affiliate ID Checkbox----------------------------------------------------1 20 Y1 21 N1 34 Yproblem is I can not have the same sponsor ID for multiple rows, even with different data in all the other columns....how do you go about doing something like this?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...