Please HELP easy ANSWER

2001-02-09 Thread Steven Fruchter
Hi Everyone, I have a big problem, that I bet could be solved pretty simply but I am new to mysql so its killing me and my database. Ok heres the problem, suddenly out of no where when my php script tries to (or manually) do a insert it says: ERROR 1062: Duplicate entry '127' for

Re: Please HELP easy ANSWER

2001-02-09 Thread btjones
Try this instead: CREATE TABLE custinfo ( id int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT, date date, name varchar(50), card varchar(22), exp_date varchar(7), authcode varchar(8), amount double(4,2), tax double(3,2), pnref varchar(16), address text, city tinytext, state varchar( 3), zip