[SQL][PHP] Sortowanie tematów wg. postów Opcje

[PiotrekM]

Witam,
potrzebuje posortować tematy wg. postów czyli tak jak na każdym forum. Temat z najnowszą odpowiedzią ląduje na górze.
Uklepałem takie zapytanie, ale nie działa. Nie sortuje oraz zamiast id tematu zwraca id postu :/

[SQL] pobierz, plaintext 
SELECT * FROM zt_topics LEFT JOIN zt_posts ON zt_posts.topic = zt_topics.id GROUP BY zt_topics.id ORDER BY zt_posts.id DESC
[SQL] pobierz, plaintext 

Ten post edytował PiotrekM 15.02.2010, 15:14:15

[PiotrekM]

kurde felek, całkowicie zapomniałem

zt_topics

[SQL] pobierz, plaintext 
CREATE TABLE IF NOT EXISTS `zt_topics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `points` int(11) NOT NULL DEFAULT '0',
  `cat` int(11) NOT NULL,
  `autor` int(11) NOT NULL,
  `data` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `agent` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `guessed` int(11) NOT NULL DEFAULT '0',
  `stick` int(1) NOT NULL DEFAULT '0',
  `close` int(1) NOT NULL DEFAULT '0',
  `tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `wheen` int(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
 
--
-- Zrzut danych tabeli `zt_topics`
--
 
INSERT INTO `zt_topics` (`id`, `title`, `url`, `points`, `cat`, `autor`, `data`, `agent`, `guessed`, `stick`, `close`, `tags`, `wheen`) VALUES
(1, 'Cancion del adios ', 'Cancion_del_adios', 5, 2, 1, '21.01.2010, 16:59', '', 0, 0, 0, '', 0),
(2, 'La quolpe', 'La_quolpe', 0, 1, 1, '21.01.2010, 16:59', '', 0, 0, 0, '', 0);
[SQL] pobierz, plaintext 

zt_posts

[SQL] pobierz, plaintext 
 
--
-- Struktura tabeli dla  `zt_posts`
--
 
CREATE TABLE IF NOT EXISTS `zt_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `topic` int(11) NOT NULL,
  `autor` int(11) NOT NULL,
  `good` int(1) NOT NULL DEFAULT '0',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `data` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `agent` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;
 
--
-- Zrzut danych tabeli `zt_posts`
--
 
INSERT INTO `zt_posts` (`id`, `topic`, `autor`, `good`, `content`, `data`, `agent`) VALUES
(5, 2, 1, 0, 'dfsdfddf', '21.01.2010, 16:59', ''),
(6, 1, 1, 0, 'vsdggsg\r\ndgd\r\n\r\ndgs\r\nsdg', '21.01.2010, 16:59', ''),
(4, 1, 1, 0, 'dssf', '21.01.2010, 16:59', ''),
(7, 1, 0, 0, 'fg\r\ng\r\ng\r\ngf', '21.01.2010, 16:59', ''),
(8, 1, 1, 0, 'dsdggsd\r\ndg\r\n', '21.01.2010, 16:59', ''),
(9, 2, 1, 0, '\r\ndg\r\ng\r\nds\r\nsgd', '21.01.2010, 16:59', ''),
(10, 1, 1, 0, 'dgd\r\n\r\ndgs\r\ngd\r\ng', '21.01.2010, 16:59', ''),
(11, 2, 1, 0, 'hhgdfh', '21.01.2010, 16:59', ''),
(12, 1, 1, 0, 'dsffsd\r\nf\r\nfsd', '21.01.2010, 16:59', ''),
(13, 1, 1, 0, 'ffgfggf', '21.01.2010, 16:59', '');
[SQL] pobierz, plaintext