php - How could I filter duplicates? -
information:
table = giveaway
form 1 = id
form 2 = username
form 3 = userid
form 4 = wish
end of information
i trying make filter through duplicate usernames , userids
note: people enter userid , username (it giveaway)
can post me code that?
try one:
select `username`,`userid` `giveaway` group `username` having count(`username`) > 1 union select `username`,`userid` `giveaway` group `userid` having count(`userid`) > 1
Comments
Post a Comment