Well I thought I had it right, until I tried to submit an entry that was not in the table for a particular storeID but it was there for another storeID. So how can I block duplicate entries in the ccode column but only for the same storeID?
Here is the recordset I have for the duplicates recordset.
SELECT ccode
FROM visitorcodes
WHERE ccode = colname OR print = printcol
would I just have to set up something else in the WHERE clause like
WHERE ccode = colname OR print = printcol AND storeid = storecol
and then in the variable a $GET or $POST ?
I am trying to figure this out but it's kind of over my head