REPLACE on table

[blackwinged]

Hi!

My table consists of

id int (prim key,auto_inc);
value1 int;
value2 int;

I know insert a row, let's say

value 1 = 3;
value 2 = 5;

id is auto incremented!

then, another row
value1=5;
value2=7;

I know want to avoid that a set of data exists twice in the table

so, if I'd insert again 3,5 mysql shouldn't create a new dataset, but overeide the existing.

I know there is a REPLACE, but it doesn't help. Id I turn value1 UNIQUE, I couldn't insert a set like 3,6 or so

thanks!

[sdjensen]

Before inserting the values into db, check if they exists in the db and if they do, replace the values (why do you need to replace the values if they are the same as the one your replacing???) and if they does not exists in the db insert them into the db

[blackwinged]

Hi

Since The variables I wish to insert into the table are generated by a html form, I have to either check or replace an existing entry!

I could, as stated, check if the comibination of data exists, but that would be a couple of querys more and I'd like to use a more elegant way!