Jump to content


Photo

Distinct ordering problems


  • Please log in to reply
No replies to this topic

#1 SpiKeRs

SpiKeRs
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 28 June 2003 - 08:45 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users