I have two fields...both are not unique, but both can't be the same.
So two fields:
user | fruit |
So lets say the above was my table, notice how both fields are not unique. You notice Angel appears 3 times and has a different fruit for each one.
So now I have this HTML form where you can select the user's name in a pulldown box and the type of fruit also in a pulldown box. So lets say if the end user selects Angel in the user's pulldown, and Apple for the fruit pulldown. The end user then clicks submit form and now I need a way to not allow this duplicate, since the combo Angel and Apple already exists.
Is there some sort of INSERT INTO statement where it inserts 2 values if and only those 2 values dont already exist.???