Re: I'm confused



_Raven wrote:
I am getting an error when adding info to table. I am getting mysql error for duplicate entry.

You aren't giving any info on how your table looks like, so it's a bit more guessing here.

I would use AUTO_INCREMENT for the uid column, this way you don't have to inject it when you add a new user to your table.

INSERT INTO mytable (name,state) VALUES ('joe','texas')


The column is a unique one, but the data I'm inserting is unique from the other entries.

Are all columns unique? then you limit quite much what you can enter into your table, only the uid should be unique and a primary key.



//Aho
.