MySql question

What exactly are you trying to do with mysql script? just curious. i'm also building a program using mysql, this one is a database for a school but i figured to put it on a webpage. do you think it's a good idea? i'm a bit doubtful. but it's working though

I'm not entirely sure from that lot as its often awkward to tell from just one side of the text without seeing its architecture and what you want to achieve. Does it actually put the data into the correct columns in your table? Are the insertion statements correctly defined to match the table itself? Does that error appear in plain text when you try to enter the data, or is that the layout of your table? It would help to know what exactly you want your code to do and subsequently what it is doing instead. You say you are inserting as instructed (by whom and are they right).. that doesn't really help, because if its the code that's the problem i can't advise without seeing it as it might need correcting.

Duplicate Entry means that data already exist and can't be inserted again. So, you said that you figured it out but what was the problem. Sorry, it is 4 months now but couldn't resist muself.

most probably the "user" field was a unique/primary key and an entry with containing the "80profits" data already exists, i suggest performing an existence check first before performing the insert statement