Glaanieboy
OSNN Veteran Addict
- Joined
- 6 Mar 2002
- Messages
- 2,628
I have the following table (for a forum I am building):
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:
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?
Code:
+----------+--------+--------+------------+--------------+------------+
| 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:
Code:
+----------+--------------+------------+
| threadid | title | name |
+----------+--------------+------------+
| 2 | Welcome! | G-Man |
| 1 | No title | Glaanieboy |
+----------+--------------+------------+