SQL: SELECT uid, username, extcredits6 FROM [Table]members WHERE extcredits6>0 ORDER BY extcredits DESC LIMIT 20
Error: Unknown column 'extcredits' in 'order clause'
程序文件跟数据库有冲突,请使用正确的程序文件上传上去覆盖
An error report has been dispatched to our administrator.
ALTER TABLE `cdb_posts` ADD `flower` INT(10) DEFAULT '0' NOT NULL;
ALTER TABLE `cdb_posts` ADD `egg` INT(10) DEFAULT '0' NOT NULL;
ALTER TABLE `cdb_threads` ADD `flower` INT(10) DEFAULT '0' NOT NULL;
ALTER TABLE `cdb_threads` ADD `egg` INT(10) DEFAULT '0' NOT NULL;
DROP TABLE IF EXISTS `cdb_felog`;
CREATE TABLE `cdb_felog` (
`id` mediumint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`fromuser` varchar( 15 ) NOT NULL default '',
`touser` varchar( 15 ) NOT NULL default '',
`asfe` varchar( 8 ) NOT NULL default '',
`tid` varchar( 15 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) TYPE = MYISAM CHARSET = GBK;