I was trying to make the email address unique.

how do i fix making the password unique.

I don't see how.

ALTER TABLE `users` ADD UNIQUE(`password`)


that's what it says.