Hi,

on my current project I've come across something which I don't-know-how myself. This is not a thing of figuring but simply knowing.

I'll firstly post an idea of what I'm looking for, followed by some practical explanation.

----------------

SELECT * FROM `reports` WHERE EntryID is unique

Means if the table holds EntryID #5 twice, it will return it only once.

----------------

Okay, so there's this contest where you can enter in. Now, people can report entries of which they think they don't belong there.
Let's move on to the moderator page. There's a page that will show all reports. However, there will surely enough be multiple reports of the same entry. Imagine the table looks like so:

ReportID, Reporter, EntryID
1, 2, 5
2, 3, 5
3, 4, 6
4, 5, 5

I wouldn't want the page to display the reports for EntryID #5 three times.

That's it !

Big Thanks!