MyChenQL, part 7

[filburt1]

I want information (for now just SELECT *) about the latest datetime for each forumid.

I have a theory though which I'm trying now.

[filburt1]

Idea didn't work:

mysql> select forumid,datetime,10000000000 - datetime as datetimediff,subject from posts group by forumid order by datetimediff;
+---------+------------+--------------+------------------------------+
| forumid | datetime   | datetimediff | subject                      |
+---------+------------+--------------+------------------------------+
|       2 | 1041623792 |   8958376208 | first thread in second forum |
|       1 | 1041622466 |   8958377534 | first thread                 |
+---------+------------+--------------+------------------------------+
2 rows in set (0.00 sec)

[filburt1]

*sigh* Unforuntately it looks like I'll have to use a cache of some sort

[Xenon]

SELECT forumid, MAX(datetime) as datetime, subject FROM posts GROUP BY forumid ORDER BY datetime

[filburt1]

Nope.