ORDER BY -nur wie???- Die DB

[Fabi]

hast du denn überhaupt eine spalte namens threadid in deiner tabelle?

Meine DB:

CREATE TABLE boards (
boardid int(120) NOT NULL auto_increment,
boardname varchar(120) NOT NULL default '',
PRIMARY KEY (boardid)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

INSERT INTO boards (boardid, boardname) VALUES (1, 'Test-Forum');

CREATE TABLE posts (
threadid int(120) NOT NULL default '0',
username varchar(120) NOT NULL default '0',
post longtext NOT NULL
) TYPE=MyISAM;

INSERT INTO posts (threadid, username, post) VALUES (1, 'Admin', Test.\r\n\r\Test test test. ;)\r\n\r\n Text text\r\n\r\n\r\nViel Spass.\r\n Admin');

CREATE TABLE threads (
boardid int(120) NOT NULL default '0',
threadid int(120) NOT NULL auto_increment,
topic varchar(120) NOT NULL default '',
PRIMARY KEY (threadid)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

INSERT INTO threads (boardid, threadid, topic) VALUES (1, 1, 'Ein Forum');