CREATE TABLE `heste` ( `id` int(11) NOT NULL auto_increment, `race_id` int(11) NOT NULL default '0', `type` varchar(50) character set latin1 collate latin1_danish_ci NOT NULL, `aargang` varchar(4) character set latin1 collate latin1_danish_ci NOT NULL, `navn` varchar(50) character set latin1 collate latin1_danish_ci NOT NULL, `stangmaal` varchar(4) character set latin1 collate latin1_danish_ci NOT NULL, `afstamning` varchar(150) character set latin1 collate latin1_danish_ci NOT NULL, `dressur` varchar(50) character set latin1 collate latin1_danish_ci NOT NULL, `spring` varchar(50) character set latin1 collate latin1_danish_ci NOT NULL, `farve` varchar(50) character set latin1 collate latin1_danish_ci NOT NULL, `pris` varchar(6) character set latin1 collate latin1_danish_ci NOT NULL, `beskrivelse` longtext character set latin1 collate latin1_danish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-- -- Data dump for tabellen `heste` --
INSERT INTO `heste` VALUES (1, 32, 'Pony', '2001', 'Hest :P', '400', '?', '??', '???', 'Brun', '87000', 'Beskrivelsen kommer til at stå her...'); INSERT INTO `heste` VALUES (2, 32, '', '1998', 'hest 2', '300', '', '', '', 'Sort', '90000', ''); INSERT INTO `heste` VALUES (3, 23, '', '1997', 'hest 4', '56', '', '', '', 'Sort', '75000', '');
$query = mysql_query("SELECT DISTINCTROW r.id, r.race FROM racer AS r INNER JOIN heste AS h ON r.id = h.race_id ORDER BY r.race ASC") or die (mysql_error());
Det burde altså virke. Du er sikker på at du har nogle racer med id 32 og 23?
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.