MySQL Insert Error

[easethan]

Hey, I'm using MySQL version 3.23.32 and whenever I insert something into a table that is identical to another row, it does not insert. For example, if a user fills out a form for two items, and they fill both forms out identically, then the second one will not insert, either that or the second one gets inserted deleting the first one, which is unlikely because I am using the auto_increment extra to generate row id's and the id for the first one never gets edited. Any help is appriciated on why it does this and how it can be fixed or avoided.

[yousaf931]

Post your SQL Query.

It would help us to understand. What is going on.

Cheers,
yousaf FAYYAZ.

[easethan]

The Query makes no difference in this case, I have had this problem with multiple queries on a variety of scripts, using different syntaxes of writing the queries, whenever all of the fields to be inserted as a row match exactly a row that is already in the table, it does not insert it. I am however running this on my own computer, using Apache 1.3 and PHP 4.0. I installed MySQL, Apache, and PHP using a free multiprogram server installer called PHPTriad 2.11, now known as Sokkit. I don't use Sokkit because it isn't free.