MySQL / PHP - 'DISTINCT'

[joe-php]

For the table newboard - there are columns
id,board,thread,depth,senter_id,subject,message,time,ip

I want to make a "top 10 recent threads" page.

Therefore, the columns board,thread,time are important.

I need to see the threads ordered by time, where board AND thread are
distinct. How do I do it so they are BOTH distinct?

Each "board" has an 'id' - one of about 30 numbers. Each "thread" is a
"thread" within that board. So "Board 5" might have a thread "20" - and also
"board 25" might have a thread "20"

I need to make sure that the combo of board and thread doesn't appear twice
in the sql call - so that i can get my "top 10"

Any ideas? I know DISTINCT has something to do with it, but I'm not sure how
to involve distinct with TWO things.

[olaf]

Do you have only one table for this?

[joe-php]

hi

just the one table

information about the boards is stored in another table, but information about the postings in the boards is all stored in this one table

[olaf]

Hallo,

i have never used it, but read the mysql-doc about the statement "GROUP BY" I think this could help