[MySQL] Selecting data using DISTINCT

[Glaanieboy]

I have the following table (for a forum I am building):

+----------+--------+--------+------------+--------------+------------+
| threadid | postid | userid | name       | title        | body       |
+----------+--------+--------+------------+--------------+------------+
|        1 |      1 |      0 | Glaanieboy | No title     | Hello!!!   |
|        1 |      2 |      0 | Glaanieboy | RE: No title | Hi!!!      |
|        2 |      3 |      0 | G-Man      | Welcome!     | I am here! |
+----------+--------+--------+------------+--------------+------------+

What I want is to select threadid, name and title, but only the distinct two threadid's, meaning I should get a result like this:

+----------+--------------+------------+
| threadid | title        | name       |
+----------+--------------+------------+
|        2 | Welcome!     | G-Man      |
|        1 | No title     | Glaanieboy |
+----------+--------------+------------+

I have tried using the query: "SELECT DISTINCT threadid, title, name FROM forum ORDER BY threadid DESC;", but that shows also the double threadid's, it's like I used a query without the DISTINCT part. Can someone help me please?

 

[Khayman]

Try adding
GROUP BY threadid

 

[Glaanieboy]

I changed ORDER BY to GROUP BY and it works! Thanks Khayman!