[Solved] PHP SQL / Duplicate entries

by


Create a unique index on Col A and Col B:

MySQL:

ALTER TABLE `mytable` ADD UNIQUE `unique_index`(`ColA`, `ColB`);

ANSI SQL example:

ALTER TABLE mytable ADD CONSTRAINT unique_index UNIQUE (ColA,ColB);

2

solved PHP SQL / Duplicate entries