Question

因此,我开始我的ding夫MYSQL。

CREATE TABLE IF NOT EXISTS `my_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`school_division` int(11) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`email` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

现在我要向最近加入该班级的学生介绍。如何做? 我尝试如下。

"SELECT * FROM my_users WHERE school_division={$divsion} ORDER BY  id  DESC LIMIT 0 , 5";

但是,它只列出前五名学生。这些学生是第一批加入的使用者。我怎样才能获得最后5名学生加入?

Answer 1

http://www.un.org/Depts/DGACM/index_spanish.htm

 "SELECT * FROM my_users WHERE school_division={$divsion} ORDER BY  date  DESC LIMIT 0 , 5";

Answer 2

by:

"SELECT * FROM my_users WHERE school_division={$divsion} ORDER BY date DESC LIMIT 0 , 5";

Answer 3

<代码>id为auto_increment栏。因此,通过提一下该栏最后五个最高数值,可以很容易地完成最后五个用户的检索。具体通过<代码>进行订购页: 1

Answer 4

You should order by date instead of id, like:

$sql = "SELECT * FROM `my_users` WHERE `school_division`= ".$divsion."  ORDER BY `date` DESC LIMIT 0 , 5"

Or, if you somehow must order on id...do an order by id ascending instead of descending.

Answer 5

按日期分列的无补贴令

“选举* WHERE 学校:师资 a. 按日期分列的数字:0,5”

Answer 6

我认为,这应该是应该的。

ORDER BY `id` DESC

不是半殖民地

友情链接