View Single Post
Old 03-05-2013, 07:08 AM   PM User | #2
Arcticwarrio
Regular Coder

 
Arcticwarrio's Avatar
 
Join Date: May 2012
Location: UK
Posts: 581
Thanks: 15
Thanked 65 Times in 65 Posts
Arcticwarrio is on a distinguished road
thats only looking to update a record, if it were blank then the row would be wmpty and you would need to INSERT it

or maybe try another blank key:

PHP Code:
INSERT INTO opl_comp(gamenamegamecoderegionmodevmcsmbhddusbnotescomp)VALUES('$gamename''$cleangc''$region''$mode''$vmc''$smb''$hdd''$usb''$notes''$comp'WHERE gamename'' 
ON DUPLICATE KEY UPDATE gamename=('$gamename'), region=('$region'), mode=('$mode'), vmc=('$vmc'), smb=('$smb'), hdd=('$hdd'), usb=('$usb'), notes=('$notes'), comp=('$comp'"; 
__________________
There are 10 types of people on CodingForums,
Those who understand Binary and those who dont.
Arcticwarrio is offline   Reply With Quote