Ühe tabeli sorteerimine teise tabeli alusel (MySQL)

  • kaupo k 23 a

    Nimelt on küsimuse all foorumi teemade sorteerimine viimase postituse aja alusel.

    SELECT forum_topics.id, forum_topics.user_id, forum_topics.topic_name, MAX(forum_posts.time)
    FROM forum_topics LEFT JOIN forum_posts ON forum_posts.topic_id = forum_topics_.id WHERE forum_topics_.category_id = ';$category_id'; GROUP BY forum_topics.id

    Sellise query';ga ta küll väljastab kenasti iga teema viimase posti aja ning postija kuid ei sorteeri neid viimase posti alusel. Niisiis ongi küsimus selles kuidas seda saavutada?

    04. veebruar 2002 - 10:31:47 · Otselink

  • kaupo k 23 a

    RTFM =)

    SELECT forum_topics.id, forum_topics.user_id, forum_topics.topic_name, MAX(forum_posts.time) AS timestamp FROM forum_topics LEFT JOIN forum_posts ON forum_posts.topic_id = forum_topics_.id WHERE forum_topics_.category_id = ';$category_id'; GROUP BY forum_topics.id ORDER BY timestamp DESC

    04. veebruar 2002 - 10:42:11 · Otselink