help with phpmyadmin making an sql

Hi everyone,
I'm trying to make a new database using phpmyadmin and the sql query window.
CREATE TABLE tblUsers (
fldId INT NOT NULL AUTO_INCREMENT,
fldUsername VARCHAR(40) NOT NULL,
fldPassword VARCHAR(40) NOT NULL
);

does anyone know why this code won't work.
Thanks for any help

phpmyadmin gives this error:

Quote:

---

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

---

so, add the key to your auto-increment column:

Code:

---

CREATE TABLE tblUsers (
fldId INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
fldUsername VARCHAR(40) NOT NULL,
fldPassword VARCHAR(40) NOT NULL
);

---