search

cYbercOsmOnauT / wysiwygsceditorphpbb

8 stars 11 forks source link

Fix duplicates in the emoticons dropdown #14

Closed Ky0suke closed 8 years ago

Ky0suke commented 8 years ago

Group emoticons by URL to avoid duplicates in the sceditor emoticons dropdown.

cYbercOsmOnauT commented 8 years ago

Wouldn't it be better to use DISTINCT instead of GROUP BY?

Ky0suke commented 8 years ago

With MYSQL, DISTINCT won't work with multiple columns. We'll still have duplicates, so i suggest using GROUP BY.

cYbercOsmOnauT commented 8 years ago

Ah yes. You are right. I did oversee that we get 2 columns. Thank you! Merged.