On duplicate key updating all fields

Databases
1

i’m having a problem with this query. I have a table with 9 fields, but i only want to update 1 of the fields on duplicate key. For some reason it’s updating all my fields…

if ($OLD_DATA[register] = ‘0’) {

			$sql = "INSERT INTO card (pc, forcexport)
			        VALUES ('$NEWPC', '1') ON DUPLICATE KEY UPDATE forcexport='1'";
		}
2

could you do a show create table and post the output ?

PS. I’m not interested in the data in the table, only the structure :slight_smile:

3

CREATE TABLE card (
pc int(8) NOT NULL,
active_date date default NULL,
first varchar(15) default NULL,
last varchar(15) default NULL,
email varchar(30) default NULL,
phone varchar(11) default NULL,
register tinyint(3) NOT NULL default ‘0’,
NotesPublic text,
NotesInternal text,
transfered varchar(255) default NULL,
forcexport tinyint(4) default ‘0’,
PRIMARY KEY (pc)
) ENGINE=MyISAM DEFAULT CHARSET=latin1