如何在PHP / mysql中更新行？

Question

I import outlook contacts file into my database and then display it into html table. The table is created and everything is ok, but when I try to upload it a second time, all names and information is doubled. So what I want to do is if the first name and the last name already exists just to update the row and all cells in that row and not insert that row over and over again.

"CREATE TABLE contacts(PID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(PID),first_name CHAR(80),middle_name CHAR(80),last_name CHAR(80)"

I tried with on duplicate key update/replace but it didnt work.

"INSERT INTO contacts (first_name,middle_name,last_name)
VALUES ('$first_name','$middle_name','$last_name')"

I guess my problem is in the auto_increment and primary key but I don't really understand how they work and how to do that.

Answer 1

Your INSERT would never "update" your existing record, because you're missing the "on duplicate key" business:

INSERT INTO sometable (field1, field2) 
ON DUPLICATE KEY UDPATE field1=VALUES(field1), field2=VALUES(field2)

and of course, this will only work if the INSERT would actually cause a duplicate key violation. The only unique index you have in your table is the primary key, and you're not inserting a value into it at all, so there will NEVER be a duplicate key violation.

You probably want an UPDATE query instead:

UPDATE yourtable
SET field1='value for field1', field2='value for field2'
WHERE id=$your_record_id