打开数据库问题

[gaoyinfeng]

当按某字段从大到小排列时用:sql="select * from myquestion order by id desc";
当只打开某字段内容等于某值时用:sql="select * from [user] WHERE name='"& username &"'"
那么我只打开name字段含username的行,且按id号从大到小排列该怎么写呢?谢谢!

[starytx]

sql="select name from myquestion where name='username'order by id desc"

[moodboy1982]

sql="select * from [user] WHERE name='"& username &"' order by id desc"
如果用
sql="select name from [user] WHERE name='"& username &"' order by id desc"的话，那只能显示name这个字段。其它的信息显示不了。

[starytx]

楼主的要求就是那样嘀~