MySQL help

[aa-true-vicious]

My php:

<?
mysql_query("INSERT INTO `users` ( `username` , `password` , `email` , `planet` , `join` , `style` , `active` , `code`) values ('$username', '$encode', '$email', '$planet', '$datetime', '$style', 'no', '$code')");
echo mysql_error();
?>

And my table:

CREATE TABLE users (
id int(10) unsigned NOT NULL auto_increment,
username text NOT NULL,
password text NOT NULL,
email text NOT NULL,
planet text NOT NULL,
join datetime NOT NULL default '0000-00-00 00:00:00',
style text NOT NULL,
active enum('no','yes') NOT NULL default 'no',
code text NOT NULL,
forumaccess int(11) NOT NULL default '0',
resources bigint(20) NOT NULL default '0',
researching enum('no','yes') NOT NULL default 'no',
rtime int(10) unsigned NOT NULL default '0',
rtopic int(10) unsigned NOT NULL default '0',
rr int(11) NOT NULL default '0',
adr int(11) NOT NULL default '0',
rank int(11) NOT NULL default '0',
move enum('up','down','same') NOT NULL default 'same',
news longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY rank (rank)
) TYPE=MyISAM COMMENT='holds basic info on all users';

I am returned:
Duplicate entry '0' for key '2'

What does that mean and how do I fix it?

[majiclab]

You have defined a unique key on the field rank. The default for field rank is 0. In your INSERT statement, there is no definition for rank, so it is defaulting to 0. However, MySQL is only going to let you have one user with rank 0.

That is where your problem is... To fix it, you will somehow have to set the rank when inserting to a number that isn't being used by somebody else. Since I'm guessing their rank will be high when they first signup (as they haven't climbed up the ladder yet), you could just do a: "SELECT MAX(rank) FROM users" and then add 1 to that result and you will get the next rank.

Hope that helps!

-Percy

[aa-true-vicious]

Thanks

I forgot about the rank field...