Complicated SQL Query Line

[NZ_Kiwi]

I have two tables.

I want to get the last five results from one table. In this table there is a $main_id in it. Now these five results can not have the same $main_id in it.

So it may well select results 1 2 3 4 6 as result 5 has the same $main_id as result 4.

Any ideas?

[superwormy]

SELECT DISTINCT main_id ...

Soemthing along those lines might work, check out the MySQL manual for the DISCTINCT clause...

[NZ_Kiwi]

Originally posted by superwormy
SELECT DISTINCT main_id ...


Soemthing along those lines might work, check out the MySQL manual for the DISCTINCT clause...

Sweet so I have this

$result = mysql_query ("SELECT DISTINCT thread_id From forum_posts limit 5");
while ($row = mysql_fetch_array($result)) {

But I also need other things out of it. Such as the topic name... how do i do this??

$result = mysql_query ("SELECT DISTINCT thread_id, title From forum_posts limit 5");
while ($row = mysql_fetch_array($result)) {

???

[NZ_Kiwi]

I now have this code

$result = mysql_query ("SELECT DISTINCT thread_id, title, main_id, datestring From forum_posts order by datestring desc limit 5");
while ($row = mysql_fetch_array($result)) {

but it still shows all records. So it will show two with the same $thread_id