[Resolved] what does this error mean?

[SoulFly]

i can't figure what it tells me :

Duplicate entry '0' for key 1

[laserlight]

Please provide a relevant code snippet, and some explanation.

[planetsim]

In your MySQL database you have set to have one or more feilds to be unique. Thus the reason your getting the duplicate error.

[SoulFly]

this line causes the error :

mysql_query("insert into users(nickname,password,email,signature) values('$nickname','$password','$email','$signature')") or die(mysql_error());

i set the id field to a primary key and when
i attempt to insert data into the database the error displays. nevertheless, when i drop the id field from being a primary key the error doesn't display.

how can i make the id field be a primary key and fix the error?

[laserlight]

Read planetsim's reply.

Since primary keys must be unique, there is a problem.

I suggest using INT NOT NULL AUTO_INCREMENT for your primary key.

[SoulFly]

hooooo now i got it!
thank you both.