Noob Update query problem

[genista]

Hi,

Nice and simple one but still causing me issues!

I want to change this query:

[code=php:0]
$query = "INSERT INTO
supplierimages (image1, supplierid)
VALUES ('$image1','$supplierid')";
[/code]

to UPDATE instead. The reason for this is I keep getting duplicate entry errors for the supplierid if it already exists in the database.

I won't embaress myself by posting my attempts to update, please help!


Thanks,


G

[printf]

Add a condition to the INSERT!

[code]$query = "INSERT INTO supplierimages (image1, supplierid) VALUES('" . $image1 . "', '" . $supplierid . "') ON DUPLICATE KEY UPDATE image1 = '" . $image1 . "';[/code]

printf

[genista]

Great worked a treat!

Thanks,

G

[fenway]

This is of course contigent on an appopriate unique index.