ordering problem in AUTO_INCRMENT

[zodehala]

when i order postid by ASC an abnormal ordering come to the fruition

http://img81.imageshack.us/img81/7495/snap1nc6.gif

this i my table

CREATE TABLE IF NOT EXISTS `post` (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext collate utf8_unicode_ci,
`ipaddress` char(15) collate utf8_unicode_ci NOT NULL default '',
`countcontent` varchar(250) collate utf8_unicode_ci NOT NULL default '',
PRIMARY KEY (`postid`),
KEY `userid` (`userid`),
KEY `threadid` (`threadid`,`userid`),
FULLTEXT KEY `pagetext` (`pagetext`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


where is problem ?

[abduraooft]

That's true for your query! You are ordering in terms of userid, not postid