INSERT or UPDATE based on existence

[msavvy]

My form is posting the following keys and values....

// productUID = 1234
// [attributeUID] = [INSERT/UPDATE][TEXTSTRING]

1 = 0Text sample.
31 = 1Text sample.
32 = 1Text sample.
91 = 0Text sample.
90 = 0Text sample.
92 = 0Text sample.
10 = 1Text sample.

Based on the above, I'm trying to figure out whether to use INSERT or UPDATE in the mysql db. Is there a better way of doing this?

[paulsbooker]

you have not expressed yourself very clearly here....

whether you use an insert or an update
depends on whether you have a relevant record in your table

paul

[msavvy]

Correct, that is where the leading 0/1 was on the textstring. However, it was a pain to post so I got it working on the results end.