Jump to content

Archived

This topic is now archived and is closed to further replies.

SpiKeRs

Distinct ordering problems

Recommended Posts

I am messing about with my forums. What I am wanting to achieve is to select the row with the latest date for each topic.

 




$query1 = "SELECT DISTINCT topic FROM $forum_table  WHERE status != \'Important\' AND status != \'Deleted\' ";

$result1 = mysql_db_query($database, $query1) or die ("Could not execute query: $query1. " . mysql_error() );



$query2 = "SELECT poster, subject, DATE_FORMAT(ADDDATE(date, INTERVAL 6 HOUR), \'%d %b %Y %k:%i\') as full_date FROM $forum_table  WHERE topic =\'$row1->topic\' ORDER BY date DESC";



 

The above code is what I have tried out. Its working fine apart from one problem. Query 1 basically takes 1 instance of each topic as I want but there is no way to order it so in the forums it is simply ordered by topic number and not the date so I get the impression I am not on the right track to dealing with this issue. Any help appreciated.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.