problem php mysql

[sousimou]

hello i create a table with mysql with an identifier autoincrement.
and via a form I manage to store my data in the table. my problem is
that if I remake the same data they are stored second once with a new
identifier. or as I click on precedent of the navigator and I revalide
the data they will pass under another identifier. I want that the data
are inserted only once in the table thank you

[Steve Belanger]

an auto increment field will always change as you add more records to the
database in order to insure that you have a unique value throughout the
database.

take the auto increment field as a way to pinpoint exactly what record you
want to look at, the rest of the fields will be your actual content.

hope this helps.

Steve.

"sousimou" <so******@gmail.comwrote in message
news:11*********************@e65g2000hsc.googlegro ups.com...

hello i create a table with mysql with an identifier autoincrement.
and via a form I manage to store my data in the table. my problem is
that if I remake the same data they are stored second once with a new
identifier. or as I click on precedent of the navigator and I revalide
the data they will pass under another identifier. I want that the data
are inserted only once in the table thank you

[Toby A Inkster]

sousimou wrote:

my problem is that if I remake the same data they are stored second
once with a new identifier.

Referencing earlier discussion, this is exactly the sort of reason I avoid
autoincremented primary keys.

--
Toby A Inkster BSc (Hons) ARCS
http://tobyinkster.co.uk/
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

* = I'm getting there!